![]() |
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? |
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? |
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