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