If your Excel header or footer is missing, the first thing to check is that you are in Page Layout view or Print Preview—headers and footers are not visible in the default Normal view. Switch to Page Layout view (View tab > Page Layout) or open Print Preview (File > Print) to see them. If they still don’t appear, the most common culprits are the “Different First Page” setting, a missing header/footer in the page setup dialog, or the print area not including the rows/columns you expect.
Why Headers and Footers Seem to Disappear
Excel only displays headers and footers in Page Layout view and Print Preview, not in Normal view. This is by design—Normal view shows only the worksheet grid, while Page Layout view mimics a printed page with margins, rulers, and the header/footer areas. If you’re working in Normal view, the header/footer is simply hidden, not deleted. Many users panic when they can’t see their header after typing it, only to realize they’re in the wrong view.
Another reason headers/footers appear missing is that they are only applied to the current worksheet. If you have a multi-sheet workbook, each sheet has its own header/footer settings. You might have added a header to Sheet1, but when you switch to Sheet2, it’s not there. This is a common source of confusion.
How to Check Your View Mode First
The quickest way to verify if your header/footer is actually missing or just hidden is to switch views. Here’s what to do:
- Click the View tab on the ribbon.
- In the Workbook Views group, click Page Layout.
- Look for the header area at the top of the page (marked “Click to add header”) and the footer area at the bottom.
Alternatively, press Ctrl+F2 to open Print Preview. If your header/footer appears there, it will print correctly. If it doesn’t appear in Print Preview, then it’s truly missing or not set up correctly.
Check Page Setup for Header/Footer Settings
If you’re in Page Layout view and still don’t see a header/footer, open the Page Setup dialog. Go to Page Layout tab > click the small arrow in the bottom-right corner of the Page Setup group. In the dialog, click the Header/Footer tab. Here you can see the currently selected header and footer. If they are set to “(none)”, that’s why you don’t see anything. You can choose a preset from the drop-down lists or click “Custom Header…” to type your own.
Also check the Sheet tab in the same dialog. Look at the “Print area” field. If it’s set to a specific range, only that range will print, and the header/footer will appear only on those pages. If the print area is wrong, your header might be on a page you’re not viewing.
Common Settings That Hide Headers and Footers
Several Excel settings can make headers/footers appear missing even when they are set. The most common are:
- Different First Page: If this option is enabled (in the Page Setup dialog > Header/Footer tab), the first page has its own header/footer. If you set a header on page 2 but not page 1, it will seem missing on page 1. Check both the “Header” and “First Page Header” drop-downs.
- Different Odd & Even Pages: Similar to above, but for odd and even pages. If enabled, you must set headers for both odd and even pages separately.
- Scale to Fit: If the sheet is scaled to fit a certain number of pages, the header/footer might be pushed off the visible area. Check Page Setup > Page tab > Scaling.
- Print Area: If a print area is defined, only that range prints. Headers/footers are not part of the print area but are applied to every printed page. If your print area is a single cell, you might only get one page with a header, but if you’re looking at the wrong page, it can seem missing.
How to Insert a Header or Footer Correctly
If you’ve confirmed that no header/footer exists, here’s how to add one:
- Go to Insert tab > Header & Footer (or use Page Layout view and click “Click to add header”).
- Type your text in the left, center, or right section boxes.
- Use the Header & Footer Elements buttons on the ribbon to add page numbers, file path, date, etc.
- Click anywhere outside the header/footer area to return to the worksheet.
Remember that headers and footers are only visible in Page Layout view and Print Preview. If you go back to Normal view, they disappear again—that’s normal.
Why Headers/Footers Might Not Print
Even if you can see the header/footer in Page Layout view, it might not print. Here are the usual reasons:
- Margins too small: If your top or bottom margin is set to 0, the header/footer might be cut off. In Page Setup > Margins tab, set the header/footer distance to at least 0.3 inches (0.75 cm).
- Printer driver issue: Some printers have a “print headers and footers” option that is disabled by default. Check your printer preferences in the Print dialog.
- Print area: If the print area is set to a range that excludes the header/footer rows (though headers are not in the sheet), the header might still print, but if the print area is a single cell, you might get a very small page and the header might be cut off.
- Page breaks: If you have manual page breaks, the header/footer appears on each page, but if a page break splits a row, the header might appear on a page that you don’t expect.
What to Do When Headers/Footers Are Missing on Some Pages
If your header/footer appears on page 1 but not on page 2, check the “Different First Page” or “Different Odd & Even” settings. To disable them:
- Go to Page Layout tab > Page Setup launcher.
- Click the Header/Footer tab.
- Uncheck “Different first page” and “Different odd and even pages”.
- Click OK.
If you want the same header on all pages, make sure these options are unchecked. If you want a different first page header, set it in the “First Page Header” box.
Frequently Asked Questions
Why can’t I see the header/footer in Normal view?
Excel only shows headers/footers in Page Layout view and Print Preview. Normal view is for editing data, not for seeing printed layout. Switch to Page Layout view (View tab > Page Layout) to see them.
How do I make the header/footer visible on all pages?
Ensure that “Different first page” and “Different odd and even pages” are unchecked in Page Setup > Header/Footer. Also, make sure you have set a header/footer for the “Header” and “Footer” boxes, not just for the first page.
My header/footer shows in Page Layout but doesn’t print. Why?
Check your printer settings—some printers have an option to print headers and footers that is off by default. Also, check your margins: if the header/footer distance is too small (e.g., 0), it might be cut off. Increase the header/footer distance in Page Setup > Margins.
Can I have different headers for different sections of the same sheet?
Yes, but only by using the “Different first page” and “Different odd and even pages” options. You cannot have arbitrary different headers per page unless you split the sheet into multiple print areas, which is not straightforward. For most users, the built-in options are sufficient.
Why does my header disappear when I scroll?
Headers and footers are not part of the worksheet grid. They are only visible in Page Layout view, and when you scroll, the header scrolls out of view just like any other part of the page. To keep a header visible on screen, use the “Freeze Panes” feature for rows, but that’s a different feature.
How do I remove a header/footer that won’t go away?
Go to Page Layout view, click on the header/footer area, select all the text and delete it, then click outside. Alternatively, go to Page Setup > Header/Footer and choose “(none)” from the drop-downs. If it still prints, check if there’s a first page header or odd/even header set.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- How to Turn Off Shutter Sound on iPhone
- VPN Setup on iPhone SE: Step-by-Step Guide
- Fix Internet Not Working on Windows 11
- Fix Right Click Not Working in Firefox
- Compare Two Columns with Comma Separated Values in Excel
- How to Limit Ad Tracking on iPhone Apps