wrapped text in cells not displaying

[Jock]

I have six workbooks; 5 work fine however the sixth will not display wrapped
text in cells on the main worksheet. The text does wrap, but the row height
isn't automatically adjusted to display it all.
There are merged cells in the worksheet, but not in the area with the
'wrapped' text.
I have manually adjusted the row heights for the whole sheet - would that
have an effect?
Help!

 

[Tyro]

"I have manually adjusted the row heights for the whole sheet - would that
have an effect?"

Yes. Excel will not override a manual adjustment of row height or column
width.

Tyro

 

[Gord Dibben]

Once you have manually adjusted row height, it will no longer autofit.

You must select and re-apply autofit.

Another prpblem might be the amount of text you have in the cell(s).

Excel by default will show only 1024 characters in a cell even though you can
enter 32767 characters.

Add an Alt + Enter linefeed every 80-100 chars if that's the case.


Gord Dibben MS Excel MVP