Catalog

How to Remove Header and Footer in Excel: A Step-by-Step Guide

June 26, 2023 18.4K views

Headers and footers in Excel can help add essential information, such as page numbers, dates, and titles, to your document. If you're using Excel for creating spreadsheets, you might need to remove the header and footer at some point. A header is information that appears at the top of every page of your workbook or sheet, while a footer appears at the bottom of every page. You might want to remove headers and footers from your spreadsheet if you want to print a clean copy of your document or if you don't want any unnecessary information to appear. 

How to Remove Header and Footer in Excel with Excel

Microsoft Excel is the most popular spreadsheet program used by millions worldwide. Here are the steps to remove the header and footer in Excel with MS Excel:、

Step 1: Open Your Workbook in Excel

First, you'll need to open your workbook in Excel. The process is the same for all Excel versions, whether you're using 2010, 2013, 2016, 365, or any other version. Once you've opened your workbook, navigate to the sheet where you want to remove the header and footer.

Step 2: Click on the "Page Layout" Tab

Once you've opened your workbook, click the "Page Layout" tab on the top menu bar. The tab contains all the tools related to the layout and formatting of your spreadsheet.

Step 3: Click on the "Page Setup" Group

After clicking on the "Page Layout" tab, you'll notice a "Page Setup" group in the middle of the tab. Click on this group to proceed.

Step 4: Remove the Header and Footer

In the "Page Setup" group, you'll notice an option labeled "Header/Footer." Click on this option, and a dialog box will appear. You can remove the header and footer by clearing the content from the "Header" and "Footer" sections. You can also uncheck the "Different first-page" option if you don't want a separate header or footer for the first page.

Step 5: Click on "OK"

Once you've removed the header and footer, click the "OK" button to save your changes. Your header and footer will now be removed from your sheet or workbook.

How to Remove Header and Footer in Excel with WPS

WPS Office is a free alternative to Microsoft Office and comes with its own spreadsheet program called WPS Spreadsheets. Here are the steps to remove the header and footer in Excel with WPS:

  1. Open your Excel workbook in WPS Spreadsheets.

  2. Click on the "Page Layout" tab in the ribbon.

  3. In the "Page Setup" group, click on "Page Setup".

  4. In the "Page Setup" dialog box, select the "Header/Footer" tab.

  5. In the "Header/Footer" tab, uncheck the "Header" and "Footer" check boxes.

  6. Click on the "OK" button to apply the changes.

Your Excel spreadsheet should now have no headers or footers.

Trustpilot

stars

4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User

avator

Algirdas Jasaitis

How to Remove Header and Footer in Excel with Other Tools

If you don't have access to WPS or MS Excel, there are other tools you can use to remove headers and footers in Excel. One such tool is Google Sheets. Here are the steps to remove the header and footer in Excel with Google Sheets:

  1. Open your Excel workbook in Google Sheets.

  2. Click on the "File" menu and select "Print".

  3. In the "Print settings" dialog box, click on the "Headers & footers" dropdown menu.

  4. Select the "Custom" option.

  5. In the "Custom" dialog box, delete all the content in the boxes.

  6. Click on the "Save" button to apply the changes.

Your Excel spreadsheet should now have no headers or footers.

Know More about WPS Spreadsheet

Removing headers and footers in Excel can help you achieve a cleaner and more professional-looking document. You can create a sheet that meets your specific needs by following the step-by-step guide above and customizing your sheet using the tips provided. And if you're looking for a reliable spreadsheet program, we highly recommend WPS Spreadsheet for all your data processing needs.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.