Column/Row Formating

[Guest]

I am using Office XP which inclued Excel 2002; my problem
is my row/column formating will occasionally change
without any input from me. I have several cells merged
and do not have width set to adjust for the amount of
text,just text wrap. Any ideas, I have to keep correcting
my formats.
Thanks,
Gary C.

 

[Gord Dibben]

Gary

Merged cells will allow "wrap text" from Format>Cells>Alignment but..........

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.

Gord Dibben Excel MVP