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?

On Sep 4, 11:27*am, Paul wrote:
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.

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...
--
Kevin Backmann


"Paul" wrote:

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?

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

On Sep 4, 1:26*pm, Kevin B wrote:
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.

"Paul" wrote:
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?- Hide quoted text -

- Show quoted text -