How do I clear blank space at the top of a word-wrapped text cell?

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

Guest

Often when I set cells to word-wrap and then auto-fit the row height, cells
with text will end up with a blank line or two at the top. It's not extra
spaces in the text because when I go to the formula bar, there's nothing
before the start of the text. I can manually adjust the size of each row,
but that's a hassle and not very consistent!

Thanks.
 
In the same Format, Cells, Alignment, select Top in Text Alignment Vertical.

HTH,

Carole O
 
Thanks, Carole... I did try that, but then it just moves the blank space to
the *bottom* of the cell. Either way, I end up with a row that's not the
right height for the contents.
 
You must log in or register to reply here.

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

Excel 2007 Adds Spaces when Wrap Text is Used 3
Row height setting problem 8
Cells ignore Wrap Text formatting! 2
wrap text 1
Resizing merged / wrapped cells. 2
2007 Excel: text in cell becomes hidden when formatted to wrap tex 0
wrapped text in cells not displaying 2
Excel wrapped rows, want automatically leave some space bottom of 1

Back
Top