Adjusting row height to accomidate text in a cell

G

GeorgeJ

In previous versions of Excel, when I did a format/cells/alignment and then
checked the "wrap text" box, the row height of the cell would change if that
was required to display all the text in the box. This doesn't seem to work
for me in Excel 2007. I click on a cell which has a long text string in it,
only a some of which is displayed. Doing a format cells/alignment and then
checking the box for "Wrap text" does *not* change the row height. The cell
remains showing only a porttion of the total text string in it. What am I
doing wrong?
 
O

OssieMac

Hi George,

If the row height has been previously set to a fixed height with Format->Row
height then that row height appears to take precedence.

After wrapping the text, select Format->Auto fit row height (In editing
block far right of Home tab)
 
O

OssieMac

Hi again George,

I just did some more testing and provided the rows are set to Autofit then
Wrapping text expands the cell. So you can set Autofit height either before
or after wrapping text.
 
Top