How to add header and footer to all sheets in Excel When working with a Microsoft Excel document, the header and footer will apply only to the current sheet, not the entire document.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.