Copy column width along with data??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
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.
 
Back
Top