How To Exit Header And Footer In Excel | Normal View Fix

Guides / By

Excel header and footer boxes disappear when you click a worksheet cell and switch back to View > Normal.

The moment Excel drops you into a top or bottom page box, use View > Normal; that is how to exit header and footer in Excel without deleting anything. The header or footer still exists for printing, but the worksheet goes back to the standard grid.

The small trap is that clicking outside the box only ends text editing. Excel may still stay in Page Layout view, which makes the worksheet look like printed pages. To leave the whole header and footer area, switch the workbook back to Normal view.

Exit Header And Footer In Excel Without Changing Your Print Setup

Excel keeps headers and footers tied to print layout, so leaving the editing area does not erase the print text. The direct working move is a two-step exit: click a cell, then choose View > Normal.

  1. Click any normal worksheet cell, not a header or footer box.
  2. Select the View tab on the ribbon.
  3. Click Normal in the Workbook Views group.
  4. Scroll the sheet if needed; the page-style header and footer boxes should no longer sit above or below the grid.

The header and footer text is still attached to the sheet. Print Preview can still show page numbers, file names, dates, or custom text you added earlier.

Why Does Excel Keep Showing Header Boxes?

Excel keeps showing header boxes because Insert > Header & Footer automatically moves the worksheet into Page Layout view. A page box at the top or bottom means the sheet is being shown as printable pages, not that the workbook is broken.

Microsoft notes that Excel worksheet headers and footers display only in Page Layout view, Print Preview, and printed pages. Microsoft’s Excel header and footer page explains where worksheet headers and footers appear.

That matters because there are two separate actions that feel similar:

  • Clicking a cell leaves the active header or footer text box.
  • View > Normal leaves the page-style worksheet view.
What You See In Excel What To Do What Changes
A top header box is active Click any worksheet cell The header box stops taking text
A bottom footer box is active Click inside the grid, then scroll up if needed The footer area is no longer selected
The sheet still looks like paper pages Choose View > Normal The normal worksheet grid returns
Page numbers still show in Print Preview Leave them alone if you want them printed The printed header or footer remains
You opened the Page Setup box Click OK or Cancel The dialog closes without keeping you in a text box
A chart sheet has header options Close Page Setup, then return to the worksheet The chart print header tools close
You need to remove the header text Go back to Insert > Header & Footer and delete the text The printed header content is removed

Leaving The Box Is Not The Same As Deleting The Header

Leaving the header or footer only changes what you are editing on screen. Deleting the header or footer removes the text that prints at the top or bottom of each page.

Use View > Normal when you only want the sheet back. Use the header or footer box again when you want to remove page numbers, the file path, the sheet name, or custom wording.

To delete a header or footer, select Insert > Header & Footer, click the left, center, or right header or footer area, delete the content, then click a worksheet cell and return to View > Normal. The print preview should no longer show the deleted text.

What If Normal View Does Not Hide The Header?

Normal view should hide worksheet header and footer boxes. When the boxes still appear, the sheet is often still in Page Layout view, a dialog is open, or the workbook view did not change because another object is selected.

Use this sequence:

  • Click a blank worksheet cell before choosing View > Normal.
  • Close any open Page Setup, Header, or Footer dialog.
  • Use the Normal view button on the bottom-right status bar if the ribbon is collapsed.
  • Save, close, and reopen the workbook if Excel seems stuck after switching views.

Excel for the web may show a different ribbon layout from the desktop app. When the full header and footer controls are missing in the browser, open the file in the desktop Excel app and use the same View > Normal move there.

Problem Likely Cause Next Move
Header text is gone from the screen You switched to Normal view Check File > Print before printing
Header text still prints The header was hidden, not deleted Edit the header box and remove the content
The sheet has big page gaps Page Layout view is still active Click View > Normal
The ribbon option is hard to find The window is narrow or collapsed Use the bottom-right Normal view button
A chart has header settings Chart sheets use Page Setup Close the dialog, then select a worksheet tab

Finish Back On The Grid

Excel header and footer view ends once the sheet is back in Normal view and the grid fills the workbook window. The print-only header text can stay in the file while you work on cells, formulas, tables, and charts.

  1. Click a cell in the worksheet grid.
  2. Open View.
  3. Select Normal.
  4. Use File > Print only when you need to confirm printed headers or footers.

If the goal is only to stop editing the header, one worksheet click is enough. If the goal is to exit the page view itself, View > Normal is the move that puts Excel back where most spreadsheet work happens.

References & Sources