Home 
Excel Printing Copy Print Settings
Search MS Office A-Z | Search Web Pages/ Design A-Z
Copy Print Settings
To copy print settings from one sheet to another:
- Select the sheet with the settings you want to copy.
- Hold down the Shift (or Ctrl) key and click on the tab (or tabs) of the other sheet (or sheets) you want to copy the settings to.
- Choose File | Page Setup, and click OK. By doing so, you will copy all the basic print settings from the active sheet to all the others in your temporary group. (You'll also copy header and footer settings.).
Home Excel Printing Copy Print Settings
Search MS Office A-Z | Search Web Pages/ Design A-Z