ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   FormatRowAutofit (https://www.excelbanter.com/excel-discussion-misc-queries/191917-format-row-autofit.html)

fostertom

FormatRowAutofit
 
Hi

in Excel 2003, I have a 380row x 2col sheet, all text, no functions so far.
Text was imported from Word, other Excels etc. Up to 10 lines of text in some
cells, word-wrapped, many new-line (Alt + Enter) breaks. No merged cells.

Problem is, FormatRowAutofit is unreliable. For 90% of cells works fine
but some either show white space between text lines, or shrink too much,
cutting off last text line(s). If adjusted manually, seems unstable - will
revert for no reason. Can I lock all, once perfect?


All times are GMT +1. The time now is 07:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com