Wordwrapping within a cell

[KJB]

I have a cell's formatting set to word wrap, which it
does, up to a point. After a couple of paragraphs of
text, the word wrapping function seems to stop and the
sentence suddenly trails off into the abyss. I've
attempted to adjust the cell's size and several formatting
options but nothing seems to work. I've reentered the
text data into blank cells, new worksheets, and even re-
typed the entirety of the text. I thought perhaps the
1,024 character limit was a cause, but if I adust the
cell's size by width, it allows more characters to show.
It will not however word wrap after that specific point.
Any ideas will be appreciated. Thank you.

 

[Dave Peterson]

You can have a cell that contains about 32k worth of characters, but left to its
own devices, excel will only show about 1000.

You can add alt-enters to force new lines within your cell and you can see more.

If by chance, you use merged cells, you'll have to adjust the rowheight
yourself--it won't react nicely to autofitting the rowheight.