Fix Excel Headers and Footers Not Visible in Page Layout View
Question details
Headers and footers are not displaying when viewing an Excel worksheet in Page Layout view.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Preparing a worksheet for printing and reviewing the document structure in Page Layout view.
- Observed behavior
- Configured headers and footers remain invisible because the top or bottom margins are set too small, physically covering the header and footer display areas.
Verify that you have actually inserted content into your headers and footers, and ensure you are in Page Layout view, as Normal view hides these elements by default.
Increase Top and Bottom Margin Values
Adjusting the custom margins expands the page area, preventing the margins from covering your headers and footers.
In Excel, headers and footers require a specific amount of space at the top and bottom of the page. If the overall top and bottom document margins are smaller than or equal to the header and footer margins, the content will be hidden or cut off in Page Layout view.
Open your Excel worksheet and click on the 'Page Layout' tab located on the top ribbon.
Click the 'Margins' button in the Page Setup group, then select 'Custom Margins' at the bottom of the drop-down menu.
In the Page Setup dialog box, locate the 'Top' and 'Bottom' margin input boxes. Increase these values so they are larger than the 'Header' and 'Footer' values shown in the same window.
Click 'OK' to save the changes. Return to the Page Layout view to verify that the headers and footers are now properly displayed.
Manage Headers, Footers, and Margins Easily with WPS Office
WPS Spreadsheet provides a highly intuitive Page Layout view, allowing you to visually adjust margins and format headers and footers without dealing with complex settings. It seamlessly handles all your printing preparation needs.
- 1. Open Your Spreadsheet: Launch WPS Spreadsheet and open your document.
- 2. Switch to Page Layout: Navigate to the 'View' tab and click on 'Page Layout' to see your document as it will print.
- 3. Access Margin Settings: Go to the 'Page Layout' tab, click 'Margins', and choose 'Custom Margins'.
- 4. Adjust Header Space: Increase your Top and Bottom margins to make room for your headers and footers, then click 'OK'.
Frequently Asked Questions
Why can't I see my headers and footers in Normal view?
Normal view in Excel is optimized for data entry and calculation. It intentionally hides print-specific elements like headers, footers, and page margins to save screen space. You must switch to Page Layout view or Print Preview to see them.
How do I specifically change the header and footer margins?
Go to Page Layout > Margins > Custom Margins. In the Page Setup window under the 'Margins' tab, you will see dedicated input boxes labeled 'Header' and 'Footer'. Adjust these values to control how far the headers and footers are from the edge of the paper.
Will 'Scale to Fit' settings hide my headers and footers?
Scaling settings adjust the size of your worksheet data, not the headers and footers. However, if your margins are incredibly tight, heavy scaling might push data into the header/footer space, causing visual overlaps. Correct margin spacing prevents this.
