Microsoft Excel is a famous data analysis software. Header and footer in MS Excel are used to add consistent information at the top and bottom of each sheet. These include the page number, date, title, etc. Sometimes, you may want to add or close the header and footer in the Excel sheet.
How to add or close the header and footer in Excel? This article will help you learn how to close the header and footer in Excel. Stay with us.
Part 1: What Are the Header and Footer in Excel?
Header and footer in Excel help you to create a standard document with unique formatting. The content of the header and footer are repeated on each sheet. A header is added at the top of the sheet, while a footer is added at the bottom. You can add consistent information in the header and footer, e.g., page number, logo, title, date, etc. You can add a header and footer in the Excel sheet by Clicking the Insert tab and then selecting the drop-down menu under the Text option.
How to Add the Header in Excel?
When you create a new worksheet, no header is included. Following these steps, you can add a header to the sheet.
Step 1: Open the Excel sheet.
Step 2: Go to the Insert Option located at the top.
Step 3: Select the drop-down menu under the Text tab.
Step 4: Select Header and Footer from the different options available.
Step 5: In your worksheet, click the Add Header section to add header information such as page number, title, etc.
Step 6: Different design options are available for the header and footer. To use these options, click in the header section and then click the Design tab from the main menu. You can quickly add Page number, Number of pages, current date, current time, file path, file name, sheet name, and pictures in the header by clicking the required option from the Header &Footer Elements section.
How to Add a Footer in Excel?
You can also add consistent text at the bottom of all sheets. Follow these steps to add a footer to the worksheets.
Step 1: Open the Excel sheet.
Step 2: Go to the Insert tab, and select the drop-down menu under the Text option.
Step 3: Select the Header and Footer from the different options available.
Step 4: Click the Add Footer option at the bottom of the sheet to add footer information.
Step 5: Go to the Design tab to add different elements quickly from the options available in the Header & Footer Elements section. These elements include the Page number, Number of pages, current date, current time, file path, file name, sheet name, and pictures.
Part 2: How to Close the Header and Footer in Excel 2016 and Other Versions?
Closing the header and footer in Excel is also a simple process. You can use any of the following methods to close the header and footer in the Excel sheet. You can use these methods on any version of Excel.
Method 1. Using the Page Setup Option
Step 1: Go to the Page Layout option from the main menu.
Step 2: Click the arrow under the Page Setup section highlighted in the picture below.
Step 3: In the Page Setup dialog box, select the Header/Footer tab.
Step 4: Select None from the Header and Footer sections to close the header and footer and click the OK button.
Method 2. Using the View Option
This is the simplest process to close the header and footer. This method is highly recommended, as you can close the header and footer with just a click.
Step 1: Switch from the Page Layout to the View tab.
Step 2: Select Normal from the Workbook Views section.
How to Remove Header and Footer in Excel?
If you want to delete the header and footer, you can also remove the header and footer from your worksheet. Follow these steps.
Step 1: Open your Excel sheet.
Step 2: Select the right, left, or center header or footer text box.
Step 3: Press the Delete or Backspace key to delete the header or footer.
How To Close the Header and Footer in Excel Mac?
Step 1: Open Excel on Mac.
Step 2: Select Normal from the View option in the Workbook Views section.
Step 3: To show the header and footer again, go to the View option and select Page Layout in the Workbook Views section.
Important Reminder:
Headers and footers are simple and intuitive, enhancing the user experience while maintaining document standards. Remember to save changes and explore print preview options to ensure the desired outcome.
Part 3: Edit Your Excel Spreadsheet for Free - WPS Office
WPS Office is a powerful and modern office suite, widely used by millions of people worldwide. Professionals and students are opting for WPS Office due to its fantastic features. WPS Office is free to use. It is available for Windows, Mac, Linux, Android, and iOS devices. You can easily add or remove the header and footer in WPS Office Spreadsheet software.
Fantastic Features of WPS Office
Free To Use
WPS Office is free to download and use. There are no subscription charges associated with using WPS Office. You can use the standard version of WPS Office free of cost. If you want to use the Business or Premium versions of WPS Office, a nominal subscription cost is associated with it.
WPS 365
WPS Office is also available as a web version. If you do not want to download and install the standalone software, you can use the web version called WPS 365. WPS 365 includes Docs, Sheets, Slides, Teams, Drive, and many tools to increase productivity.
All-in-one Free Office Suite
WPS Office is a complete Office suite including all office productivity solutions. WPS Office has the following applications packaged in it.
Writer - to create, open, and edit Word documents
Spreadsheet - to create, open, and edit Excel worksheets
Presentation - to create and design stunning PowerPoint presentations
PDF - to open and edit PDF files
Besides these, WPS also includes other useful tools, e.g., document converter, screen recorder, auto backup, file repair, and many more.
How to Add the Header and Footer in WPS Office?
WPS Spreadsheet is a fantastic software to create, open, and edit Excel worksheets. You can follow these steps to add the header and footer to the WPS Office Spreadsheet.
Step 1: Open your Excel worksheet in WPS Office.
Step 2: Click the View tab and select the Settings option.
Step 3: Select from the preset header and footer elements or create a custom header and footer from the Page Setup window.
How to Close the Header and Footer in Excel - WPS Office?
Step 1: Go to the View option in the menu bar.
Step 2: Select Normal from the Workbook Views option.
FAQs
1. How to fix the header and footer with scrolling content in Excel?
If you want to see the header and footer while scrolling a large Excel sheet, you can lock the header and footer. To use this feature, go to the View option and select the Freeze Pane and then select your desired options.
2. How do I set the default header and footer in Excel?
You can set the default header and footer in Excel by following these steps.
Step 1: Open the Excel sheet.
Step 2: Insert header and footer by selecting the Insert option and selecting the drop-down menu under the Text option.
Step 3: Click the header or footer in the document and select the drop-down list under the Header or Footer to set the default header and footer. This list includes many built-in header and footer elements, e.g., Page number, Number of pages, current date, current time, file path, file name, sheet name, and pictures.
How to Close the Header and Footer in Excel - Key Points
The header and footer help to maintain the standardization of the document. You can add different elements in the header and footer sections. These elements will display on all sheets in the Excel documents. You can easily add, remove, and close the header and footer sections by using the methods discussed in this article.
You can use WPS Office to create and edit your Excel worksheets. WPS Office helps you to easily add and remove headers and footers in your Excel worksheets. WPS Office is a robust office suite, available on all platforms including Windows, Linux, Mac, Android, and iOS. You can download WPS for free from its official website.
