AutoFit not working properly

  • Thread starter Thread starter zxcv
  • Start date Start date
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.
 
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.
Click to expand...

Post in ONLY ONE GROUP
 
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.
Click to expand...

Post in ONLY ONE GROUP
 
Back
Top