Fix Missing Headers and Footers in Excel Print Preview
Question details
The user needs worksheet headers and footers to appear in Excel Print Preview and on printed pages.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Previewing or printing a worksheet with a header or footer.
- Observed behavior
- The header and footer do not appear in Print Preview or on the printed page.
Open the affected workbook and select the worksheet you want to print. Check that the sheet contains data and that you are editing a page header or footer, not row and column headings.
Check the Print Area and Header or Footer Settings
Use this method to make sure Excel has a printable worksheet range and a header or footer assigned to the selected sheet.
Select the affected worksheet tab and confirm that it contains data in the range you want to print.
Select the cells to print, then choose Page Layout > Print Area > Set Print Area. To remove an incorrect existing area instead, choose Page Layout > Print Area > Clear Print Area.
On the Page Layout tab, open the Page Setup dialog using the small launcher in the Page Setup group. Select Header/Footer, then choose a preset or use Custom Header or Custom Footer to enter content.
Choose View > Page Layout to inspect the page, then open File > Print and confirm that the correct sheet and print range are selected.

Check Page Margins and Excel Print Settings
Use these checks if the header or footer is configured but still does not appear in the preview.
Preview and Print Spreadsheet Headers With WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening compatible Excel workbooks and working with spreadsheet headers and footers. It can provide another way to prepare a printout, although it does not repair Excel's own settings.

Frequently Asked Questions
Why is my Excel header missing from Print Preview?
The selected sheet may not have a header assigned, the printable range may be incorrect, or a different first-page or odd/even-page header may be empty. Check Page Layout > Page Setup > Header/Footer and review the print area.
How do I change the print area in Excel?
Select the cells you want to print, then choose Page Layout > Print Area > Set Print Area. To remove the existing print area, choose Page Layout > Print Area > Clear Print Area.
Are headers and footers the same as row and column headings?
No. Headers and footers appear in page margins; row and column headings are the numbered rows and lettered columns. Configure page headers and footers under Page Layout > Page Setup > Header/Footer.
Why does the header appear on some pages but not the first page?
Open Page Layout > Page Setup > Header/Footer and check Different first page. If it is enabled, enter content for the first-page header or turn off the option if you want the same header throughout.




