can I change page layout in an entire existing Excel workbook?

[LJL]

I have an existing Excel workbook with some 20 worksheets in it. I would like
to change the page orientation and margins for the entire workbook without
having to do it for each worksheet individually. Is there a way to do this?

 

[Per Jessen]

Select all sheets by right clicking a sheet tab and click "Select All
Sheets", now goto Page set up and do what you want.
Click a non active sheet tab to de-select all sheets.

Hopes this helps.
....
Per

 

[LJL]

Excellent! Thanks very much.

Lee

Select all sheets by right clicking a sheet tab and click "Select All
Sheets", now goto Page set up and do what you want.
Click a non active sheet tab to de-select all sheets.

Hopes this helps.
....
Per