How to Add Headers/Footers to all Worksheets in a Workbook at the Same Time (Excel 20072010)
If you are using all the worksheets in a workbook, and want to add the same header and/or footer to all the sheets, it can be done so they are all added at the same time.