Jennifer has attended:
Excel Intermediate course
Macro
How to apply same header/footer to all sheets?
RE: Macro
select and group all the sheets, goto any sheet that you want to insert the header/footer, type in the header/footer, ungroup the sheets, and you will have the header/footer on all the sheets.