| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a single header/footer common across all worksheets?
I have 15 worksheets in a file, and each needs the same header & footer. I
have tried control-clicking to highlight each tab & then "Page Setup" to change the header/footer, but only get the first worksheet clicked to 'take' the header/footer. Is there some way to do a mass change to avoid tediously clicking into & copy-pasting the information into individual worksheets? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set up single Header/Footer for all tabs in Excel Workbook. | Excel Worksheet Functions | |||
| Common header/footer in Excel | Excel Discussion (Misc queries) | |||
| can you set a default header and footer for ALL worksheets? | Setting up and Configuration of Excel | |||
| Header & Footer make template for multiple users | Excel Discussion (Misc queries) | |||
| make custom header and footer in excel apply to all worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
