Printing Problems

Fix a Missing Excel Header or Footer in Print Preview

Kushani NimanthikaKushani Nimanthika Nov 18, 2026 869 views

Question details

Find out why a custom Excel header or footer is missing from print preview, especially in a downloaded template.

How to Fix a Missing Excel Header or Footer in Print Preview
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.
Before you start

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.

Solution 1Recommended

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.

1
Switch to Page Layout view

Select View > Page Layout to inspect the worksheet. Headers and footers are not visible in Normal view.

2
Inspect the header or footer

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.

3
Check page-specific options

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.

4
Preview the worksheet

Select File > Print and check the preview, including any additional pages, for the header or footer.

Check the Excel view and header or footer settings
Free Microsoft Office alternative

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.

Add headers and footers to spreadsheets before printingOpen and edit Microsoft Excel XLS and XLSX filesWork with a familiar spreadsheet interfaceMove existing workbooks to a lightweight office suite
microsoft office alternative - wps office

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.