Copy Worksheet to Preserve Page Set Up

[TiChNi]

I have a workbook with a very detailed worksheet that I want to copy
onto addtional worksheets to run different scenarios. I can easily
copy the worksheet but it doesn't preserve the detailed page set up for
printing. How do you get it to copy the page set up too?

Thanks

 

[Macgru]

I have a workbook with a very detailed worksheet that I want to copy
onto addtional worksheets to run different scenarios. I can easily
copy the worksheet but it doesn't preserve the detailed page set up for
printing. How do you get it to copy the page set up too?

Thanks

did you try to right click on sheet's name and copy to new/ another
workbook?
macgru

 

[TiChNi]

No, I want all the sheets to be in the same workbook but don't want to
have to reset the page setup on every single new sheet. I want the
page set up (margins, headers, layout, etc.) to be copied with the
original worksheet data to the new sheets.

 

[Gord Dibben]

TiChNi

Just right click on sheet tab and "move or copy".

Checkmark "create a copy".

Page setup will be copied also.


Gord Dibben Excel MVP