| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I duplicate headers and footers on multiple sheets?
I have a worksheet that has a custom header and footer and I want the exact
same header and footer on sheet 2 and I can not find a way to copy the info to other sheets without copying and pasting each section separatly. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I duplicate headers and footers on multiple sheets?
Just group the sheets before you apply the header/footer;
click first sheet, hold down shift and click last sheet, apply the header/footer ungroup the sheets -- Regards, Peo Sjoblom "HeatherDBecerra" wrote in message ... I have a worksheet that has a custom header and footer and I want the exact same header and footer on sheet 2 and I can not find a way to copy the info to other sheets without copying and pasting each section separatly. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I duplicate headers and footers on multiple sheets?
Thank you sooooo much!! It worked!!
"Peo Sjoblom" wrote: Just group the sheets before you apply the header/footer; click first sheet, hold down shift and click last sheet, apply the header/footer ungroup the sheets -- Regards, Peo Sjoblom "HeatherDBecerra" wrote in message ... I have a worksheet that has a custom header and footer and I want the exact same header and footer on sheet 2 and I can not find a way to copy the info to other sheets without copying and pasting each section separatly. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Headers and Footers | Excel Discussion (Misc queries) | |||
| Headers and Footers in VBA | Excel Discussion (Misc queries) | |||
| How do I copy headers/footers to multiple different workbooks? | Excel Discussion (Misc queries) | |||
| headers footers | Excel Discussion (Misc queries) | |||
| Headers & footers | Excel Discussion (Misc queries) | |||
Hybrid Mode
