Excel 2003 autofit ignored by some rows

[Paul]

Format->Row->Autofit properly adjusts the heights of most rows, but
some rows seem to ignore Autofit. They are not tall enough, and some
of the text is not visible. I've found report of this on the web, but
no fixes. Any ideas, or just plain commiseration?

 

[Paul]

Format->Row->Autofit properly adjusts the heights of most rows, but
some rows seem to ignore Autofit.  They are not tall enough, and some
of the text is not visible.  I've found report of this on the web, but
no fixes.  Any ideas, or just plain commiseration?

Actually, the rows aren't ignoring AutoFit, they are simply
miscalculating the height to be one line of text too little. If I
stretch out the height before autofit, Autofit resizes the height by
shortening it too much.

 

[Kevin B]

Have you checked the cells that are not adjusting and verified that they're
not merged cells. It sounds like it could be merged cell issue to me.

Hope this helps...

 

[Paul]

Yes, quite sure that there are no merged cells in the problematic
rows.