Sahil Aggarwal 
Headers and Footers in Excel are sections at the top and bottom of the pages that contain text, page numbers, dates or file names. These are helpful but to make a professional looking spreadsheet without any extra element you need to clean these.
When we remove headers and footers it improves readability, ensures better printing and makes Excel sheets look polished. This blog will provide you a step-by-step guide to remove headers and footers using Excel, WPS office and other tools.
Limited Slots — Get 1-on-1 Expert Guidance Now!
How to Remove Header and Footer in Excel
It is easy to remove header and footer from your excel sheets using excel. Here are the steps that you need to follow to know how to remove header and footer in Excel:
Step 1: Open Your Workbook in Excel
Open Microsoft Excel and the workbook that contains the header and footer that you wish to remove. If your workbook has multiple sheets, select the one you need to edit. Removing headers and footers will only affect the active sheet unless you select multiple sheets at once.
Step 2: Click on the “Page Layout” Tab
Click on the “Page Layout” tab in excel ribbon which is present at the top of screen. This tab has many options which are related to printing and formatting such as margins, orientation, size and page setup.
Step 3: Click on the “Page Setup” Group
Within the Page Layout tab, find the Page Setup group. Click the arrow in the right bottom corner to open the full page setup dialog box. This will help you to manage headers, footers and other print settings in detail.
Step 4: Remove the Header and Footer
To remove the header and footer follow the following:
Page Setup Dialog Box → Header/Footer tab → Set both to none from drop down menus.
This will remove all the existing headers and footers including page number, dates and file names.
Step 5: Click on “OK”
After following the above step click on OK to save the changes. To verify you can use the print preview feature under File → Print. This sheet will be free from headers and footers and make it ready for printing or sharing.
How to Remove Header and Footer in Excel with WPS
WPS office is a free alternative to Microsoft Excel. WPS allows users to remove headers and footers easily. Here is a step-by-step guide to remove header and footer:
- Open your spreadsheet in the WPS office.
- Go to Page Layout or Layout tab in the top menu.
- Locate the header & footer option.
- Select the option Remove Header and Remove Footer.
- Save your changes and check the print preview to ensure that headers and footers are removed.
WPS office supports Excel file formats like .xlsx and .xls so that you can edit your Excel files directly without converting them.
How to Remove Header and Footer in Excel with Other Tools
If you do not have Excel or WPS, other tools can also help you remove headers and footers:
Google Sheets
To remove the header and footer using excel sheets you need to follow the given steps:
- The first step is to upload your Excel file to Google Sheets.
- Go to File > Print.
- In the print settings, find Headers & Footers and uncheck all options to remove them.
- Save the sheet.
LibreOffice Calc
- Open the Excel file in LibreOffice Calc.
- Click Format > Page, then go to the Header/Footer tab.
- Select No Header and No Footer, then click OK.
Conclusion
Removing headers and footers improved the presentation of your excel sheet. After removing headers and footers you can always use print preview to verify the results. By knowing how to remove header and footer in excel you can easily make your sheets look professional. You can do this via different options other than Excel like google sheets, LibreOffice Calc or some online excel editor tools which helps to edit excel sheets very quickly.
