AutoFit rows - excess space in rows

[Michael J. Malinsky]

This seems to happen when you have the Wrap Text option enabled in
Format>Cells>Alignment and the single line of text comes thisclose to the
right of the column. What I usually do is just a little extra to the column
width until the autofit gets the row to be a single line.

HTH.
Mike.


--
Michael J. Malinsky

Hi all

I've been noticing in a couple of workbooks lately that sometimes the

AutoFit function does not work properly, and I end up with an extra line of
blank space at the bottom of some of my rows.

I can't figure out why this happens, and I can't work out how to stop it.

Does anyone else have any ideas?

 

[Guest]

Hi all

I've been noticing in a couple of workbooks lately that sometimes the AutoFit function does not work properly, and I end up with an extra line of blank space at the bottom of some of my rows.

I can't figure out why this happens, and I can't work out how to stop it. Does anyone else have any ideas?

Thanks
Mary

 

[Guest]

Thanks Mik

The problem I'm finding is that with a long enough document there is always some text that comes too close to the edge of the cell. I think adjusting my Normal style to the font & size I'm using in the document has taken care of this problem, but I'll have to see

Mary