Copy column width along with data??
 

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

Copy column width along with data??
 

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



--


Regards,


Peo Sjoblom



"JR Hester" wrote in message
...
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

Copy column width along with data??
 

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... editpaste specialpaste column widths.

regards
FSt1


"JR Hester" wrote:

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

Copy column width along with data??
 

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

"JR Hester" wrote:

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

Copy column width along with data??
 

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.

"Peo Sjoblom" wrote:

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



--


Regards,


Peo Sjoblom



"JR Hester" wrote in message
...
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