Column.AutoFit

[Davers]

Hi everyone...just an annoyance more of a problem, but when I use the EntireColumn.AutoFit, it takes my word wrapped headers and unwraps them putting 2 words side by side as opposed to one on top of the other. Is there a way to use something like an autofit to get the columns to resize, but maintain the headers word wrap?

Thanks,

Dave

 

[Von Pookie]

Moved to Excel Questions.

 

[texasalynn]

Try putting in a [hard] Enter. Do this by going into edit the cell and put the cursor between the word you want to put on the second line and press Alt + Enter together. This will keep a carriage return and when you auto-fit the columns it doesn't change.

HTH
texasalynn

 

[Davers]

Thanks, I'll give it a shot!

Have a good weekend!

Dave

 

[Davers]

It worked like a charm!! Thanks again!

Dave