It is a very common practice to re-use spreadsheets for new purposes. Whether it is a report that you redo on a weekly or monthly basis, or a spreadsheet that was sent to you from another person, it can be a real time saver to simply edit some information instead of recreating the entire file from scratch.
But a spreadsheet can contain some information that is specific to a particular instance of a file, and that information is often contained within the header of the file. Adding information to a header makes a printed copy of the spreadsheet much easier to identify, but subsequent uses of that file for other purposes can mean that the information contained in the header is no longer accurate. Our tutorial below will show you how to delete the information in your header completely so that you can print the file without that information, or so that you can add new information to the header.
Removing a Header from an Excel 2013 Spreadsheet
The steps in this article will show you how to remove existing text from the header section of your Excel 2013 spreadsheet. After following the steps below, be sure to save the spreadsheet so that the header information remains gone the next time you open the file.
Step 1: Open your spreadsheet in Excel 2013.
Step 2: Click the Insert tab at the top of the window.
Step 3: Click the Header & Footer button in the Text section of the navigational ribbon.
Step 4: Click once on the header text to select all of it, then press the Backspace key on your keyboard to delete it. Note that if your header information is contained in multiple sections of the header, then you may need to repeat this step for each section of the header.
If you want to reduce the size of the top margin where the header had previously been displayed, then you can click on the bottom section of the top margin on the ruler at the left side of the screen and drag it up. To learn more about adjusting page margins, check out this tutorial on Microsoft’s site.
For a helpful change that can improve the readability of your spreadsheet, consider adding the top row to every page of your document. This can make it much easier for readers to know which column a cell belongs to.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.