Fix a Missing Excel Header or Footer in Print Preview
Question details
Find out why a custom Excel header or footer is missing from print preview, especially in a downloaded template.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Previewing or printing a worksheet that should contain a custom header or footer.
- Observed behavior
- The expected header or footer does not appear in print preview.
Open the affected workbook and select the worksheet you want to print. If it is a downloaded template, check whether the header or footer is intended for the first page or for odd and even pages.
Check the Excel view and header or footer settings
Use this solution to confirm that the header or footer contains text and is assigned to the page you are previewing.
Select View > Page Layout to inspect the worksheet. Headers and footers are not visible in Normal view.
Click the header or footer area and check the left, center, and right sections for the expected text. Enter the text in the appropriate section if it is missing.
Click the header or footer area and review Different First Page and Different Odd & Even Pages on the Header & Footer tab. If either option is enabled, check the corresponding page's header or footer.
Select File > Print and check the preview, including any additional pages, for the header or footer.

Check the Excel print area and margins
Use this solution if the header or footer is present but still does not appear on the expected printed pages.
Print spreadsheets with WPS Office
WPS Office is a free, lightweight alternative for opening and printing spreadsheets. Its familiar interface and Excel format compatibility make it easy to move existing workbooks to WPS Spreadsheets. It does not change Excel's own print settings.

Frequently Asked Questions
Why can't I see my Excel header in Normal view?
Excel does not display headers and footers in Normal view. Select View > Page Layout or File > Print to see them.
Why does the header appear on some pages but not the first page?
The Different First Page option may be enabled. Click the header area in Page Layout view, check that option on the Header & Footer tab, and add a first-page header if needed.
Can a print area affect which pages I see in preview?
Yes. A print area limits the worksheet content included in printing. Select Page Layout > Print Area to clear an incorrect area or set a new one, then check File > Print.
Where can I adjust space for a header or footer?
Select Page Layout > Margins > Custom Margins and review the top, bottom, header, and footer margin settings. Select OK and check the result in File > Print.




