Tip #154_Excel

Excel: Extend Page Setup Settings to Other Sheets


SCENARIO – You have a multi-sheet Excel file. You have applied numerous Page Settings to Sheet1:

  • Landscape orientation
  • Legal size
  • Custom ½” margins
  • A custom footer
  • Print-to-fit scaling
  • Print titles (to repeat at the top of each page)
  • Single-side printing


You would like the other sheets (Sheet2, Sheet3, etc.) to have the same Page Settings – without having to repeat the steps on each page.


No problem-o!


Full tip: Excel tip