copy & paste worksheet with print settings into new worksheet
 

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?

copy & paste worksheet with print settings into new worksheet
 

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
wrote:

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?