Can I copy a worksheet with its page setup and print formats?

[Guest]

Is there a way to maintain the page setup and print formats when copying a
worksheet? Our admin assistant wants to be able to set up the print margins,
header/footer, page orientation, etc. one time and then make multiple copies
of the worksheet within the same workbook.

 

[Jim Rech]

When you copy a worksheet (not just the cells but the entire worksheet) you
get the same page setup. To copy a sheet just hold Ctrl down and drag the
worksheet tab to the right or left. Or right click on the tab and select
Move or Copy.

--
Jim
| Is there a way to maintain the page setup and print formats when copying a
| worksheet? Our admin assistant wants to be able to set up the print
margins,
| header/footer, page orientation, etc. one time and then make multiple
copies
| of the worksheet within the same workbook.

 

[Guest]

Thanks Jim, I'll give that a try!
D