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?