How to Add a Footer to All Sheets in Excel. Adding a footer to all of your sheets in an Excel workbook is a good way to ensure continuity between each sheet, especially if you are printing them out.

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.

You don't have to add a header to every Excel worksheet individually when you can group them first. Adding a header (or footer) to an Excel sheet is a simple task using Excel’s Page Layout view.