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

  • Thread starter Thread starter sjkling
  • Start date Start date
S

sjkling

is there a way to change the layout of all sheets in a workbook at one time?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update multiple sheets 1
move worksheet to end of another workbook 3
Collapsing all groups 0
how do I apply formatting from one worksheet to a whole workbook? 5
Use Formula from another worksheet 3
copy excel workbook to new workbook without data 3
WorkBook Update 3
Excel Macro to un-mute Audio/speakers. 15

Back
Top