![]() |
Excel 2003 autofit ignored by some rows
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? |
Excel 2003 autofit ignored by some rows
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. |
Excel 2003 autofit ignored by some rows
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? |
Excel 2003 autofit ignored by some rows
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 - |
All times are GMT +1. The time now is 01:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com