| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can you change the page layout of all sheets in a workbook
is there a way to change the layout of all sheets in a workbook at one time?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can you change the page layout of all sheets in a workbook
You can Group all the sheets together by right-clicking on a sheet tab
and selecting Group All Sheets. Then whatever action you take on one sheet will be reflected on all the sheets, so you can click on File | Page Setup and play about with the settings and these will affect all sheets. Remember to ungroup the sheets when you are finished. Hope this helps. Pete On Oct 9, 9:02*pm, sjkling wrote: is there a way to change the layout of all sheets in a workbook at one time? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can you change the page layout of all sheets in a workbook
Note:
Some features are not available using this method. Print Range and Rows to Repeat at Top cannot be set on grouped sheets. You would need VBA to do that. Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 13:25:17 -0700 (PDT), Pete_UK wrote: You can Group all the sheets together by right-clicking on a sheet tab and selecting Group All Sheets. Then whatever action you take on one sheet will be reflected on all the sheets, so you can click on File | Page Setup and play about with the settings and these will affect all sheets. Remember to ungroup the sheets when you are finished. Hope this helps. Pete On Oct 9, 9:02*pm, sjkling wrote: is there a way to change the layout of all sheets in a workbook at one time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page layout - page setup - items disabled | Excel Discussion (Misc queries) | |||
| Automatic page numbering with multiple sheets in a workbook | Excel Discussion (Misc queries) | |||
| Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
| Can't change page layout to print one sided for the wholeworkbook | Excel Discussion (Misc queries) | |||
| How do Icreate link from page of contents to sheets in workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
