Z
zxcv
I have a cell formatted to wrap. I put in a value that is two words,
"Column plan". The row height is 25.50 so enough room for 2 lines in
the cell. If I make the column very narrow and then either double
click it or call a macro with Selection.Columns.AutoFit it only goes
to 5.57 wide and loses the "n" in column to the second line:
Colum
n plan
How can I get this to automatically size properly to look like:
Column
plan
?
In other words I want to do an AutoFit that will be as wide as my
widest word.
Note I am using Excel 2003 but my users could have other versions.
"Column plan". The row height is 25.50 so enough room for 2 lines in
the cell. If I make the column very narrow and then either double
click it or call a macro with Selection.Columns.AutoFit it only goes
to 5.57 wide and loses the "n" in column to the second line:
Colum
n plan
How can I get this to automatically size properly to look like:
Column
plan
?
In other words I want to do an AutoFit that will be as wide as my
widest word.
Note I am using Excel 2003 but my users could have other versions.