how to close header and footer in excel

2025

2 min read

·

31-03-2025

16

0

Share

Excel's headers and footers, while useful for adding page numbers, titles, and other information to printed documents, can sometimes be distracting when working on a spreadsheet. Fortunately, Excel offers straightforward ways to hide them, both temporarily and permanently (for the current worksheet). This guide will show you how.

Quickly Hiding Headers and Footers (View Tab)

The quickest way to toggle the visibility of headers and footers is through the View tab. This method affects only the current display; the headers and footers will still print unless you adjust print settings.

1. Open your Excel workbook. Locate the spreadsheet containing the headers and footers you want to hide.

2. Navigate to the "View" tab. This tab is typically located at the top of the Excel window.

3. Locate the "Headers & Footers" checkbox. It’s usually in the "Show/Hide" group.

4. Click the checkbox to toggle the visibility. A single click will hide them; another click will show them again.

That's it! Your headers and footers will disappear (or reappear) instantly. This is the most common and efficient way to manage their visibility during your work.

Hiding Headers and Footers in Print Settings (Page Layout)

If you want to ensure your headers and footers don't print, you need to adjust the page setup. This method ensures that even though you might see them on screen, they won't appear when you print the document.

1. Go to the "Page Layout" tab. This tab is typically located near the "View" tab.

2. Click on "Page Setup" in the "Page Setup" group. A dialog box will appear.

3. Select the "Header/Footer" tab. Within the Page Setup dialog box, locate and select the "Header/Footer" tab.

4. Choose "Custom Header" or "Custom Footer". Depending on which you want to remove, select "Custom Header" or "Custom Footer".

5. Remove the contents. Clear any existing text or images from the header or footer boxes. To ensure they don't print, leave the boxes completely blank.

6. Click "OK". This saves your changes and applies them to the print settings of the current sheet.

Now, when you print, the headers and footers will be absent from your output.

Frequently Asked Questions

Q: How do I hide headers and footers permanently, even after closing and reopening the workbook?

A: The methods above are temporary for the current session. There's no setting to permanently hide headers and footers across all workbooks or to prevent them from being added in the future. You must repeat the process each time you want to hide them.

Q: My headers and footers are still appearing after I've tried these steps. What should I do?

A: Double-check that you've applied the changes to the correct sheet. Make sure you're modifying the header/footer settings on the specific sheet, not a different one in the workbook. Also, ensure the "Headers & Footers" checkbox is unchecked in the View tab (for on-screen display). If the problem persists, a restart of Excel may help.

Q: Can I hide only the header or only the footer?

A: Yes, absolutely. Follow the steps above, but only clear the header or footer section accordingly, leaving the other one intact.

By using these methods, you can easily control the display and printing of headers and footers in your Excel workbooks, enhancing both your on-screen experience and the look of your printed documents. Remember to choose the method—View tab or Print Settings—that best suits your immediate needs.