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.

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
"MSSAC_QA" wrote in message
...
| 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.

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

"Jim Rech" wrote:

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
"MSSAC_QA" wrote in message
...
| 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.