auto change

S

sharon

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
 
J

Joel

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.
 
G

Gord Dibben

Sharon

Copy your data and Paste then before hitting ENTER, Paste Special>check "Columns
Widths" but unless you select entire rows the row heights cannot be copied.


Gord Dibben MS Excel MVP
 
J

Joel

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