Copy settings 1 tab to another?

[markg2]

Office '07

Assume: a workbook with 12 tabs/sheets. I change the print setup for tab 1.



Problem: other than manually opening print setup for 'each' of the remaining 11 tabs, is there a way to copy the new page setup settings from spreadsheet 1 to spreadsheet 2-12?

Mark

[jamesdann]

Follow these steps to do your task.

1. Open your first worksheet that you have changed the print setup.
   
2. Select all worksheets now- You can select all worksheet in two ways.
   • Hold down the Ctrl key and click on all other sheet.
   • Or just do right click on first worksheet and click on Select All Sheets.
3. Click on Page Layout tab on the Ribbon and find the Page Setup dialogue box. You can see it by clicking at the bottom of right side in the Page Layout section.
   
4. Now click on OK in the Page Setup dialogue box.