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

is there a way to change the layout of all sheets in a workbook at one time?

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

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

On Oct 9, 9:02*pm, sjkling wrote:
is there a way to change the layout of all sheets in a workbook at one time?

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

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

On Thu, 9 Oct 2008 13:25:17 -0700 (PDT), Pete_UK
wrote:

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

On Oct 9, 9:02*pm, sjkling wrote:
is there a way to change the layout of all sheets in a workbook at one time?