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

J

Jane

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?
 
D

Dave Peterson

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.)
 
J

Jane

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.
 
D

Dave Peterson

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.
 
J

Jane

Dave,

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

Dave Peterson

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.
 

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

Top