Thread: copy & paste worksheet with print settings into new worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote