View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default can I change page layout in an entire existing Excel workbook?

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" skrev i meddelelsen
...
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?