Excel will not auto format all row heights
 

I have a large workbook that some cells will auto row hight but, it leaves a
extra line and could be a smaller height.

The cell formatting is the same as other cells that adjust correctly.
What can i do then, other then manually changing row hight?

I have done the find and replace alt 0010 and alt 0013 and the space was
still there.
also the formatting is in general with wrapped text

"Sebastian" wrote:

I have a large workbook that some cells will auto row hight but, it leaves a
extra line and could be a smaller height.

The cell formatting is the same as other cells that adjust correctly.
What can i do then, other then manually changing row hight?

If I do not word wrap the cell, it auto fits correctly.
Is this a glitch?

"Sebastian" wrote:

I have done the find and replace alt 0010 and alt 0013 and the space was
still there.
also the formatting is in general with wrapped text

"Sebastian" wrote:

I have a large workbook that some cells will auto row hight but, it leaves a
extra line and could be a smaller height.

The cell formatting is the same as other cells that adjust correctly.
What can i do then, other then manually changing row hight?

I'd guess that glitch is a good description.

If you widen the column ever so slightly, that extra "line" at the bottom may go
away (you may have to autofit the row--I don't recall if that's necessary).

But I think it's just a combination of factors that is working against you.

To make matters somewhat worse, I there have been posts that say that they
struggle to get the display on the screen perfect, but when they print, it
doesn't look right.

So you should have that to look forward to.

Sebastian wrote:

If I do not word wrap the cell, it auto fits correctly.
Is this a glitch?

"Sebastian" wrote:

I have done the find and replace alt 0010 and alt 0013 and the space was
still there.
also the formatting is in general with wrapped text

"Sebastian" wrote:

I have a large workbook that some cells will auto row hight but, it leaves a
extra line and could be a smaller height.

The cell formatting is the same as other cells that adjust correctly.
What can i do then, other then manually changing row hight?

--

Dave Peterson