ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can I change page layout in an entire existing Excel workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/237146-can-i-change-page-layout-entire-existing-excel-workbook.html)

LJL

can I change page layout in an entire existing Excel workbook?
 
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

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?




LJL

can I change page layout in an entire existing Excel workbook?
 
Excellent! Thanks very much.

Lee

"Per Jessen" wrote:

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?






All times are GMT +1. The time now is 01:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com