copy & paste worksheet with print settings into new worksheet

L

Larry Ohio

How do I copy the current month's report into a new worksheet and keep the
print settinds of the original worksheet in the new worksheet?
 
G

Gord Dibben

Not by copy/pasting cells.

You can right-click on the sheet tab and "Move or copy"

Check "create a copy" and select where you want copy of the sheet to be
inserted.


Gord Dibben MS Excel MVP

On Wed, 23 Dec 2009 04:17:02 -0800, Larry Ohio <Larry
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Print on only one page 5
Cannot copy worksheet to another file 2
Copying template from one worksheet to another 2
Copy a range data from 1 sheet to multiple selected sheets 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Number of pages in worksheet doesn't match Print Preview pages 2
copying worksheet including graphs to new worksheet 9

Top