Link to home
Start Free TrialLog in
Avatar of Steve_Brady
Steve_BradyFlag for United States of America

asked on

Row height auto-adjust is insufficient when using Wrap Text in Excel

Hello,

In Excel (2007), is there a limit to how many lines can be displayed in a cell when using Wrap Text?  If so, can that limit be adjusted?

I just opened a brand new workbook and widened a column (to 163).  I then pasted a text entry with 2050 characters into a cell in that column.  Next I selected all cells and clicked Wrap Text.

The row containing the text auto-adjusted its height but the adjustment was not enough to make the complete entry viewable.  To see how many lines the text actually needed, I pasted it into another cell in the same column and then manually adjusted the height.

I found that whereas 12 lines were needed to display the entire entry, the auto-adjust height was only sufficient to display 7 lines.

Out of curiosity, I repeated the same process with a width setting of 120.  This time the auto-adjust height was enough to display 9 lines of text but manual adjustment revealed that the entry needed 16 lines to be fully displayed.

Is there an explanation as to why the auto-adjust does not increase the height enough to display the complete entry?  Is there a work-around that will eliminate that limitation?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of rspahitz
rspahitz
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial