Auto Fit Column

[burt]

I can select a column and have it auto fit. However when I go to the next
cell in the column and it has more characters I have to again go to auto
fit. Is there a way that the column can be set to automatically auto fit
when the characters are greater?
Thanks
Burt

 

[David McRitchie]

Hi Burt,
Select the entire column then use AutoFit.

AutoFit will not work well with merged cells.
If you have merged cells look at my xlindex.htm page for Jim Rech
who has a macro to help with that.

If you have wrap turned on and you want the column a little wider, first
expand it a bit to what you think looks good then use autofit.

Autofit of the Column and Autofit of the Row are two different things
should be intuitive, but mentioned simply to be more complete.

 

[Bruce Sinclair]

I can select a column and have it auto fit. However when I go to the next
cell in the column and it has more characters I have to again go to auto
fit. Is there a way that the column can be set to automatically auto fit
when the characters are greater?
Thanks
Burt

I have just discovered the joy of paste special/column widths. Means that I
can set up one sheet and format others with the same column widths (as a
straight 'paste' puts in only the data).

I'm not sure if this feature will help you or not ... but it sure helped
me. Do it after your data is in.



Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)