Office Settings & Configuration

Restore Normal Worksheet View After Editing a Header in Excel

Bushra ParveenBushra Parveen Nov 18, 2026 869 views

Question details

Return an Excel worksheet to its standard display after opening the header and footer.

Restore Normal Worksheet View After Editing a Header in Excel
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.
Before you start

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.

Solution 1Recommended

Switch from Page Layout to Normal view in Excel

Use the View tab or the status bar to restore the standard worksheet display.

1
Open the View tab

In Excel, select the View tab on the ribbon.

2
Select Normal

Click Normal in the Workbook Views group. Alternatively, click the Normal view button near the bottom-right corner of the Excel window.

Switch from Page Layout to Normal view in Excel
Headers and footers remain in the workbook: Normal view hides the page layout areas on screen; it does not delete your headers or footers.
Free Microsoft Office alternative

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.

Work with worksheet views and page layout settingsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceGet a free, lightweight office suite
microsoft office alternative - wps office

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.