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

G

Guest

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
 
Z

Zack Barresse

Hi Peg,

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

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I matain formats when copy and pasting data from various so 3
How do I copy a paragraph from web page to excel file? 2
How do I copy cells containing drop downs? 3
How do I copy a formula from one worksheet to another? 11
How do I get the hyperlink destination cell to appear at top of sc 1
How do you copy and past data from one spreadsheet to another? 1
Copying content and formats to another worksheet 1
how do i copy a cell in worksheets 10 to the other 9 worksheets 3

Top