Add Sheet Name to Header or Footer in Excel

It’s easy to add sheet names to header or footer in Excel.

Once done, the sheet name will appear In the header or the footer of the page when you print it.

This is especially useful when you’re working with a large workbook and need to print multiple worksheets. Having the sheet name in the header or footer section allows you to quickly identify which page belongs to which worksheet.

Let’s see how to do this.

Add Sheet Name to Header or Footer

Below are the steps to add the sheet name to the header or footer of a specific worksheet:

1. Open the Excel file and activate the worksheet in which you want to add the sheet name to the header or footer section
2. Click on the Page Layout tab

3. In the Page Setup group, click on the dialog box launcher (the small tilted arrow at the bottom right edge of the Page Setup group).

Pro Tip: You can also use the keyboard shortcut ALT + P + S + P to open the page setup dialog box

4. In the Page Setup dialog box that opens, click on the Header/Footer tab.

4. Click on the Custom Header option or the Custom Footer option depending on where you want to add the sheet name. For this example, I will click on the Custom Header option.

4. In the Header dialog box that opens, place your cursor in the Left, Center, or Right section, depending on where you want the sheet name to appear on the printed sheet.

4. With the cursor in the right section, click on the Insert Sheet Name icon listed above the sections. Alternatively, you can manually enter &[Tab]

4. Click OK
5. Click OK in the Page Setup dialog box.

Now when you print the worksheet, the sheet named will automatically appear in the section where you placed the &[Tab] code.

In case you want the sheet name in the footer, you can follow the same steps click on the custom footer option in step 5.

You can check the result before printing by opening the print preview (by using the shortcut Control + P). If you’ve added the code in the header or footer, it should appear in the print preview of the worksheet (as shown below):

These parts only show up when you print the sheet or use the Print Preview. They don’t appear in the normal view of your spreadsheet. This keeps your work area clean while still adding key details to printed pages.

Note: In this example I selected one specific sheet for which I wanted the name to appear in the header or footer. If you want to apply this to all the worksheets in your workbook, select all the worksheets in one go and then follow the above steps.

If you want to remove the sheet name from the header or footer while printing, follow the exact same steps shown above and remove the code &[Tab] From the header or footer sections.

Formatting Sheet Name Code in Header / Footer

Excel allows you to do some basic formatting to the sheet name that you put in the header or footer. For example you can change the font type/size, font color, bold/italicize the sheet name, etc.

You can find the formatting options when you click on the formatting icon in the Header dialog box.

This will open the Font dialog box where you can make the changes.

You can also choose to format part of the code that you are putting in the header or photo section.

For example, if I have used &[Tab] – &[Page] to give Me the sheet name followed by the page number, I can only select &[Tab] and then click on the formatting icon to open the Font dialog box.

Now whatever formatting you apply would only be applied to the sheet name and not the page number part when printed.

Also read: How to Print the Top Row on Every Page in Excel (Repeat Row/Column Headers)

Useful Codes To Use With the Sheet Name in Header / Footer

While you can only add the sheet name to the header or footer while printing, it would be more useful to have more information such as page numbers or the date.

Below are some useful codes that you can put in the header of the footer section to get this additional information:

Other Excel articles you may also like:

• How to Print Excel Sheet on One Page (Fit to One Page)
• How to Print Comments in Excel
• How to Change Page Orientation in Excel?
• How to Set the Print Area in Excel Worksheets