Row Height Adjustment

D

DJC

The row heights did not automatically adjust to display
all the text contained in the cell.

I can manually go thru the rows and adjust them to display
all the data; however, there are too many lines that need
to be done manually.

I have tried the 'auto' adjust feature, but it does not
work. In fact, if I have manually adjusted some of the
lines and use the 'auto' adjust, the lines I have changed
will revert back to only display some of the info.

Is there a limit of data that can be contained in a cell?
Has anyone else had this problem?
 
D

DJC

Hello Mr. Kabel,

I double checked, there are no merged cells in the range
of rows.

Thank you for time and help!

Deb C.
 
D

Dave Peterson

If you have lots and lots of text, then excel kind of gives up with autofitting
rowheight.

If you manually adjusted the rowheight, excel won't touch it until you autofit
that row.

Excel says that you can put up to 32k characters in a cell, but only about a
1000 will show up. (all will appear in the formula bar, though).

But if you add some alt-enters, you can see lots more in the cell itself.
 
Top