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.