Copy column width along with data??

J

JR Hester

Is there any way to copy data from one shhet to another AND have the column
width/row hieght trasfer as well? I am accustomed to using paste special, but
this seem sNOT to include col width and row hieght.

Any way to accomplish without VBA?

Thanks
 
P

Peo Sjoblom

You can paste as column width but as row height, you have to do it in 2
operations, first for instance do edit>paste special and select values,
then repeat paste special and select column width



--


Regards,


Peo Sjoblom
 
F

FSt1

hi
paste special DOES include paste column widths. Row highth is not there so
you have half of what you want.
on the menu bar... edit>paste special>paste column widths.

regards
FSt1
 
D

Duke Carey

Right click on the tab for the sheet you want to copy. Choose "move or
copy..' from the list that comes up. Check the "make a copy" checkbox

In the top of that dialog box, choose the workbook where you want the copy
to go. Click on OK and get a perfect replica
 
J

JR Hester

Shame on me! I read the "All" option button to include all the formats.. From
now on I will remember to paste special twice, or three times to get values,
formulas, width, AND hieght.

Thanks to all who responded.
 
Top