Excel 2003 autofit ignored by some rows

  • Thread starter Thread starter Paul
  • Start date Start date
P

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?
 
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?
Click to expand...

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.
 
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...
 
Back
Top