Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I do "page set up" for a every page in a workbook at one .
I would like to set up headers and footers and other page setup options that
would propigate to all pages in a workbook without having to open and set up each page. |
#2
|
|||
|
|||
Group the sheets first, everything you then do is duplicated on all grouped
sheets. To group them, click on a sheet tab and then hold down the shift key and click on another (They will both be selected and any in between and [Group] will show in the title bar). If you wish to group non-contiguous sheets use control instead of shift. To un-group, click on any non-grouped sheet tab or right click on any grouped one and select 'un-group' Shortcut key to group/ungroup Ctrl+Shift+PgUp/Down -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "elizapo" wrote in message ... I would like to set up headers and footers and other page setup options that would propigate to all pages in a workbook without having to open and set up each page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving as web page for workbook with frozen panes | Excel Discussion (Misc queries) | |||
How to print multiple worksheets in one workbook on the same page. | Excel Discussion (Misc queries) | |||
Print Workbook Without Page Breaks Between Worksheets | Excel Worksheet Functions | |||
making a workbook into a web page. | Excel Worksheet Functions | |||
AUTO PAGE NUMBERING DIFFERENTLY FOR A WORKBOOK | Excel Worksheet Functions |