How To Close Header and Footer In Excel

If you have opened a header or footer in Excel to add a page number, date, file name, or other detail, you may be wondering how to get back to your worksheet. The quickest way to close header and footer editing in Excel is to select Close Header and Footer on the contextual ribbon tab. You can also switch to Normal view. Both methods let you leave the editing area without removing the information you added.

This guide explains how to close a header or footer in Excel, what to do if the editing controls are not visible, and how to remove header and footer content when that is what you intended. The steps apply to common desktop versions of Excel, though button names and ribbon layouts can vary slightly by version.

What Closing a Header or Footer Does in Excel

Excel headers and footers are printed details that appear at the top or bottom of pages. They can contain text, page numbers, dates, workbook information, or images such as a company logo. You usually edit them in Page Layout view, where Excel displays the worksheet as separate printable pages.

Closing the header and footer editor simply takes you out of that editing area. It does not automatically delete the content you entered. If you added a page number, for example, it remains in the footer and can appear when you print or preview the worksheet. To remove content, you need to clear the relevant header or footer section separately.

How to Close Header and Footer in Excel

The most direct method is to use the command on Excel’s contextual Header & Footer tab. This tab appears when you click inside a header or footer in Page Layout view.

• Open the worksheet that contains the header or footer.
• Click inside the header or footer area you are editing.
• Select the Header & Footer tab on the ribbon if it is not already active.
• Look for the Close group, usually toward the right side of the ribbon.
• Click Close Header and Footer.

Excel exits the header and footer editing area while keeping the existing content. You can continue working with worksheet cells, or choose a different view if you want to change how the sheet is displayed.

If you have typed text into a header or footer box but have not finished editing it, click outside the box or use the close command once the text is in place. If Excel is still actively editing text, pressing Esc may cancel the current text edit. It is not the most reliable way to leave the header and footer view, so use Close Header and Footer when you want to exit that area.

Close Header and Footer by Switching to Normal View

You can also leave header and footer editing by changing the worksheet view. This is useful if the contextual ribbon tab is missing, the ribbon is collapsed, or you simply prefer to return to the standard worksheet layout.

• Select the View tab on the ribbon.
• In the Workbook Views group, choose Normal.

You can often find the same view options using the view shortcuts near the bottom-right corner of the Excel window. Select the Normal view icon to switch away from Page Layout view. The worksheet will return to its standard grid display, and the header and footer areas will no longer be shown on the sheet.

Switching to Normal view does not remove a header or footer. It only changes how you view the worksheet. The content can still be included in a printout or shown again when you return to Page Layout view or open Print Preview.

How to Return to the Worksheet Without Deleting Content

If your goal is simply to get back to your cells, there is no need to clear the header or footer. Use Close Header and Footer or switch to Normal view, then select the cell where you want to continue working. Your existing header and footer settings will remain available.

This distinction matters when preparing a worksheet for printing. A header may hold a report title, while a footer may show page numbering. Closing the editor preserves those details. Deleting them could leave printed pages without useful labels or make a multipage report harder to follow.

To check what will print, open File > Print and review the preview. The preview helps you confirm whether the header and footer are positioned correctly and whether the content appears on the pages you expect.

How to Remove a Header or Footer in Excel

If you want to delete the header or footer rather than just close it, clear its contents or choose the blank preset. Removing a header does not automatically remove a footer, so check each one separately.

• Open the worksheet and select Page Layout view, if needed.
• Click the header or footer area that contains the content.
• Select the section containing the text, code, page number, or image.
• Delete the content, or use the Header & Footer tab to choose None from the header or footer options.
• Use Close Header and Footer to finish.

Headers and footers are divided into left, center, and right sections. If a page number appears on the right, for instance, deleting text from the center section will not remove it. Click the section where the item appears before clearing it. If you have added a picture, select the picture code or image in its section and remove it as you would other header or footer content.

Excel can also apply different headers and footers to the first page or to odd and even pages. If the content seems to remain after you remove it, check the settings on the Header & Footer tab. Options such as Different First Page and Different Odd & Even Pages can mean that another version of the header or footer is being displayed.

Why You May Not See the Close Header and Footer Button

The Close Header and Footer command is contextual, so it generally appears only while you are working in a header or footer in Page Layout view. If you are looking at the Home tab or another ribbon tab, the command may not be visible.

• Click inside the header or footer. This should make the Header & Footer tab appear.
• Check the ribbon layout. On a smaller window, some commands may be compressed or hidden in a menu.
• Expand the ribbon. If the ribbon is minimized, expand it to see the contextual controls.
• Switch to Normal view. This is a dependable alternative if you cannot locate the close command.

In some versions of Excel, the contextual tab may be named slightly differently or the command may be positioned elsewhere. Look for a tab related to header and footer tools and a command labeled Close Header and Footer. If you are using Excel for the web, the available page layout and header/footer controls may differ from the desktop application. When a control is unavailable online, open the workbook in the desktop version of Excel to use the full set of printing tools.

Header and Footer Editing Tips

Excel supports special fields that insert changing information into headers and footers. For example, you can add page numbers, the total number of pages, the current date, the workbook name, or the worksheet name. These fields may appear as codes while you edit them, but Excel displays the corresponding values in Print Preview and on printed pages.

Use Print Preview after editing to check the result. A long title may not fit in a narrow section, and a footer can be difficult to read if it is too close to the edge of the page. If a header or footer is cut off, review the page margins and the worksheet’s scaling settings under Page Layout.

If you work with multiple sheets, remember that header and footer settings can be specific to each worksheet. Selecting another sheet does not necessarily apply the same settings to it. Confirm the print preview for each sheet you plan to print, especially in a workbook with several reports or different page layouts.

Common Questions About Closing Headers and Footers

Does closing the editor delete my page number? No. Closing the editor leaves the page number or other content in place. You must remove it separately if you no longer want it.

Can I close a header or footer by clicking a cell? Clicking a cell may move you away from the active text area, but the most dependable methods are selecting Close Header and Footer or switching to Normal view.

Why can I see the header in Print Preview but not on the worksheet? Headers and footers are designed for printed pages. They are visible in Page Layout view and Print Preview, but they generally do not appear in the usual Normal worksheet view.

Will my header and footer print after I close the editor? Yes, provided the content remains in place and the worksheet is set up to print those pages. Check Print Preview to confirm the final result.

Conclusion

To close header and footer editing in Excel, click Close Header and Footer on the contextual ribbon tab. If you cannot find that command, switch to View > Normal to return to the standard worksheet display. Both options exit the editing area without removing your content.

If you want to remove a header or footer, clear its individual section or select a blank option instead. Keeping the difference between closing and deleting in mind makes it easier to finish editing, preserve useful print details, and prepare your Excel worksheet for printing.

Disclaimer: Articles are written by Humans, AI or Both. Verify Important information.