How do I get rid of extra white space when row autofit is on?

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

Guest

When row autofit is on, I get a lot of extra white space above or below text
in the cell with the most text. How do I get rid of it without manually
adjusting every row?
 
I don't get it for all the cells, but this might work for you...

make the columnwidth just a bit wider--then autofit the rowheights.

(It might just make the problem occur on different cells, though.)
 
Dave, Thanks for the response but in this case the column width would be too
wide to fit on the view page and have anything else show.
 
Then I think it becomes a manual effort.
Dave, Thanks for the response but in this case the column width would be too
wide to fit on the view page and have anything else show.
Click to expand...
 
Dave,

I was afraid of this. It seems to me that earlier versions of Excel did not
do this.
 
I think I've seen it in all versions (xl97 to xl2003).

But my bet is that it's a combination of printer driver, text in the cell and
just bad luck.

(I've learned to just accept these little peccadillos.)


Dave,

I was afraid of this. It seems to me that earlier versions of Excel did not
do this.
Click to expand...
 

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

Cell padding 1
How can I remove extra space when using autofit in Excel 2003? 3
Autofit row doesn’t always work 2
Internal margin for row height autofit 1
Excel Cell Height - white space 2
Autofit single cell text 3
Excel 2003 autofit ignored by some rows 3
Autofit rows - excess space above text in rows 1

Back
Top