"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Easily Copy Your Print Settings From One Sheet To Another


Each sheet in your workbook has its own print settings (i.e. orientation, headers and footers, margins, etc...). You select these options in the Page Setup dialog box by selecting File, Page Setup.

When you add a new sheet to your workbook, it contains Excel's default page setup settings. Many times you will have multiple sheets in a workbook that are similar and therefore you'll want them to have the same print settings.

Here's a neat trick that will allow you to quickly and easily transfer print settings from one worksheet to other worksheets in your workbook.

  1. Select the sheet tab for the sheet that has the settings you want to duplicate.
  2. While holding down the Ctrl key, select the sheet tabs that you want the print settings transferred to.
  3. From the File menu select Page Setup and click OK.
  4. That's it!
  5. No, I never missed a step! That's all there is to it!
  6. The Page Setup settings of your source sheet have been transferred to all of the other selected sheets.
Now, wasn't that easy?


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.