when youdo the paste (not paste special) a square box will be display.
selectt on the Square box "keep source column width"

"sharon" wrote:

Joel I tried this but it didnt work. Any ideas why?

"Joel" wrote:

There is a trick, but it is not automatic. After you Copy and Paste the
data. go to Paste Special on the Edit Menu. Select Format. this will copy
the format from the 1st worksheet to the 2nd worksheet.

"sharon" wrote:

I am copying data from 1 worksheet to a 2nd worksheet. What I want the second
worksheet to do is change the column width and row height automatically. Can
some help me.
Thank you