Autofit Row Height

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have different row heights on a very large spreadsheet.
However, when I wrap the text and then autofit the row
height, the row doesn't adjust properly. You can see the
text but it cuts off the bottom of characters with tails -
eg: g, y, f. Is there anyway to autofit but ensure that
there is sufficient space before and after without having
to set the Before and After spacing for the cells.

Any help most appreciated.

Thanks
Sue
 
A guess- Format Cells, Alignment tab, set the Vertical Text Alignment to Top. Hope that helps.
 
It sounds like you let the wraptext do its own thing.

If you add a few alt-enters to force new lines in the cell, you might have
better results.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofit Row Height 4
How do I autofit row height to adjust to new text on Excel form? 1
Excel 2007 - Rows - Height - AutoSize question 1
Internal margin for row height autofit 1
Autofit row height 7
Excel 2003 autofit ignored by some rows 3
Autofit Height of Rows too High 2
Excel Cell Height - white space 2

Back
Top