I have a spreadsheet with some text cells that have been formatted to word
wrap. I also set all cells to autofit the height based on the amount of
text. One line autofits, but the lines below it do not. Any ideas about how
I can get all the lines to be the correct heigh based on the number of "word
wrap" lines there are? Thanks

Hi Catherine,

Assuming that all the cells have Wrap Text applied. For example suppose
that the row of cells the text is in is row 1, then put your cursor between
the row numbers 1 and 2 and when you see a black line with a vertical two
headed arrow double-click it. This will best fit the row.

Important Point: If any of the cells that have Wrap Text also have Merge &
Center on then Excel will not best fit the row. In other words - Excel
ignores merged cells when performing best fit.

--
Cheers,
Shane Devenshire


"Catherine" wrote:

I have a spreadsheet with some text cells that have been formatted to word
wrap. I also set all cells to autofit the height based on the amount of
text. One line autofits, but the lines below it do not. Any ideas about how
I can get all the lines to be the correct heigh based on the number of "word
wrap" lines there are? Thanks

Hi Shane,

Thanks for your reply. I should have been more explicit when I described
the problem. Yes, I have word wrap selected. And I tried the double-headed
arrow on all the lines that are not auto-fitting, as well as selecting the
box in the upper left corner (that selects the entire page), and then
double-clicking the double-headed arrow between two lines. So all the things
you are mentioning (unless I'm doing something wrong) I've already tried and
are not working.

Any other ideas? I've run across this before and the only work-around I've
found is to manually adjust the line height.

Oh, the other thing: The number of characters in each cell is around 80.
Thanks!

Catherine

"ShaneDevenshire" wrote:

Hi Catherine,

Assuming that all the cells have Wrap Text applied. For example suppose
that the row of cells the text is in is row 1, then put your cursor between
the row numbers 1 and 2 and when you see a black line with a vertical two
headed arrow double-click it. This will best fit the row.

Important Point: If any of the cells that have Wrap Text also have Merge &
Center on then Excel will not best fit the row. In other words - Excel
ignores merged cells when performing best fit.

--
Cheers,
Shane Devenshire


"Catherine" wrote:

I have a spreadsheet with some text cells that have been formatted to word
wrap. I also set all cells to autofit the height based on the amount of
text. One line autofits, but the lines below it do not. Any ideas about how
I can get all the lines to be the correct heigh based on the number of "word
wrap" lines there are? Thanks