| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you change the page layout of all sheets in a workbook | Excel Worksheet Functions | |||
| How do I change a custom header in excel for an entire workbook? | Excel Discussion (Misc queries) | |||
| Can't change page layout to print one sided for the wholeworkbook | Excel Discussion (Misc queries) | |||
| How do I add a page to an existing workbook? | New Users to Excel | |||
| How do I change the default font in an EXISTING Excel workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
