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



"JR Hester" <(E-Mail Removed)> wrote in message
news:8D473835-B141-4175-BE05-(E-Mail Removed)...
> 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

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


"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

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

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 edit>paste special and select values,
> then repeat paste special and select column width
>
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
>
> "JR Hester" <(E-Mail Removed)> wrote in message
> news:8D473835-B141-4175-BE05-(E-Mail Removed)...
> > 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
>
>
>