Auto fit and text wrapping problem

[LyleB_Austin]

This is a rather long post so please bear with me.
I have a cell with a large amount of text. It is defined as 'General'.
"Wrap text" is checked. There are some manual carriage returns (Alt+Enter)
in the text When I select 'Row' --> 'Autofit', it expands the row to a
height of 242.25. Not all text is visible Adding a few more manual carriage
returns as mentioned in another post, the autofit function results in a
greater row height when using the 'Autofit' function, but it still cuts off
at the same place in the text. I can manually increase the row height to
409.5 which I understand to be a maximum in Excel 2003. Also, part way
throught the text, it just stops wrapping regardless of the row height.

My questions then are: Is there some way to get autofit to show all text or
at least expand the cell up to its maximum allowable height? and Why does
my text stop wrapping part way through the cell?

 

[Dave Peterson]

With lots and lots of text, the only way I've seen work is to add those
alt-enters every 80-100 characters.

Even then, I sometimes have to increase the rowheight manually.