Restore Normal Worksheet View After Editing a Header in Excel
Question details
Return an Excel worksheet to its standard display after opening the header and footer.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user clicked Header & Footer and wants to return to the usual worksheet view.
- Observed behavior
- Numbered boxes and a large blank header area appear because the worksheet is in Page Layout view.
Open the affected worksheet in Excel. If you are editing the header or footer, click a worksheet cell to finish editing before changing the view.
Switch from Page Layout to Normal view in Excel
Use the View tab or the status bar to restore the standard worksheet display.
In Excel, select the View tab on the ribbon.
Click Normal in the Workbook Views group. Alternatively, click the Normal view button near the bottom-right corner of the Excel window.

View and edit spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Microsoft Office format compatibility makes it easy to move existing workbooks into WPS.

Frequently Asked Questions
Why did Excel show a large blank area above my worksheet?
Opening Header & Footer can switch the worksheet to Page Layout view, which displays the header area. Select View > Normal to return to the standard worksheet display.
Where is the Normal view button in Excel?
Select View > Normal on the ribbon, or use the Normal view button near the bottom-right corner of the Excel window.
Will switching to Normal view delete my header or footer?
No. Normal view hides the header and footer areas on screen but leaves their contents in the workbook. Use Page Layout view to see them again.
How can I edit the header again?
In Excel, select Insert > Header & Footer, then click the header or footer area you want to edit.




