You can add a header and footer to Excel, and in this guide, we'll show you how. When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works.

If you want to add a header or footer to all sheets, select every sheet by right-clicking one of the sheet tabs at the bottom of the Excel screen and clicking "Select All Sheets" in the pop-up menu.

Q. How can I print a worksheet name in my spreadsheets? A. You may not realize it, but you can generate very customized headers and footers in Excel. Let’s tackle the easy one first. Open a worksheet ...