| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i change headers on all workbook sheets globally?
I have a workbook with about 30 sheets in it and I would like to change the
header and footer of each sheet without doing it individually on each sheet, can it be done once and globally change all headers and footers in the workbook? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i change headers on all workbook sheets globally?
Lots of the page setup settings can be changed by grouping the sheets.
Click on the left most tab and shiftclick on the rightmost. Then do your file|page setup stuff And then ungroup the sheets--rightclick on one tab and select ungroup sheets. Muntly wrote: I have a workbook with about 30 sheets in it and I would like to change the header and footer of each sheet without doing it individually on each sheet, can it be done once and globally change all headers and footers in the workbook? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i change headers on all workbook sheets globally?
Cheers mate, it worked a treat !
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change headers for all worksheets in a workbook? | Excel Discussion (Misc queries) | |||
| How do I change the font globally for all comments? | Setting up and Configuration of Excel | |||
| change values globally | Excel Worksheet Functions | |||
| HOW DO I CHANGE THE ORDER OF THE SHEETS IN EXCEL WORKBOOK? | New Users to Excel | |||
| How can I globally change the formatting of all my comments in Exc | Excel Discussion (Misc queries) | |||
Linear Mode
