MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Word Wrap?

Posted by Rob on July 06, 2001 11:21 AM

I have a large cell which spans across a whole page which has about 5 paragraphs of text in it. I turned word wrap on, but not all of the text is wrapping. Anyone know why?


Posted by Scott S on July 06, 2001 11:24 AM

Try adjusting the row height.

Posted by Tom Urtis on July 06, 2001 11:46 PM

Hi Rob --

In addition to Scott's reply, here are 2 other ideas:

By any chance is your "large cell" spanning more than just the whole page...text won't wrap on its own unless there is a limitation, such as the right margin of your cell (assuming your text is left-justified). Maybe try lessening the width of that wide cell.

Also, as a cheap way around the problem, you can press Alt+Enter to simulate the carriage return of a typewriter (remember them?), which creates a new line in a cell.