How to remove header and footer in Excel How to add header and footer in Excel You can add a header and footer in at least two different ways through the Insert or Page Layout tab in Excel.

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.

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