Return to Auto Row Height - 2007

[Sue C]

I've selected row heights to suit my form, but now discover that text
wrapping doesn't work (well, it does work, but I can only view the top line
of it without manually adjusting the row height). How can I get the row
height to go back to auto-adjust? Thanks. Sue

 

[Sue C]

Forget that, I just worked it out. The problem I now have is that some of
the Cells are Merged, and therefore the rows still aren't automatically
adjusting to the height required when excess text is entered. I read
somewhere that this isn't a problem if you use the 'Centre Across Columns'
feature instead of Merge. But I tried that, and still get the same problem.
Any suggestions? Thanks. Sue

 

[Shane Devenshire]

Hi,


1. Excel ignores merged cells when doing best fit. That means that it won't
best fit merged cells. There is nothing you can do about that other than
writing a macro.

2. Center Across Selection is an alternative to Merge and Center and Excel.
When you have it on Excel still ignores that cell for the purposes of best
fitting columns, however, if you apply Wrap Text on the Center Across
Selection text and then manually change the column width until the cells need
to wrap you can use best fit for the row hight.