can you change the page layout of all sheets in a workbook

  • Thread starter Thread starter sjkling
  • Start date Start date
You can Group all the sheets together by right-clicking on a sheet tab
and selecting Group All Sheets. Then whatever action you take on one
sheet will be reflected on all the sheets, so you can click on File |
Page Setup and play about with the settings and these will affect all
sheets.

Remember to ungroup the sheets when you are finished.

Hope this helps.

Pete
 
Note:

Some features are not available using this method.

Print Range and Rows to Repeat at Top cannot be set on grouped sheets.

You would need VBA to do that.


Gord Dibben MS Excel MVP
 
Back
Top