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.

On Aug 3, 3:54*pm, zxcv <zxcvnos...@yahoo.com> wrote:
> 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.

Post in ONLY ONE GROUP

On Aug 3, 3:54*pm, zxcv <zxcvnos...@yahoo.com> wrote:
> 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.

Post in ONLY ONE GROUP