How do I copy pages so that formats also arrive at the destinatio
 

Whenever I copy a worksheet to a new page, I have to reset the column widths,
Bold selections, alignments, etc. How do I copy so that the non-text
material appears at the destination? "Paste special" doesn't help. Thanks
Peg

How do I copy pages so that formats also arrive at the destinatio
 

Hi Peg,

Why does PasteSpecial not help?? Seems it has everything you're asking for.
:?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"Peg" wrote in message
...
Whenever I copy a worksheet to a new page, I have to reset the column
widths,
Bold selections, alignments, etc. How do I copy so that the non-text
material appears at the destination? "Paste special" doesn't help.
Thanks
Peg

How do I copy pages so that formats also arrive at the destinatio
 

You can copy a worksheet just by CTRL-drag in the same workbook window
- you then have an identical sheet, including column widths and all
formatting.

Hope this helps.

Pete