Copy Worksheet to Preserve Page Set Up

T

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
 
T

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.
 
G

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
 
Top