How to Delete a Header in Excel 2013

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.

click the insert tab

 

 

Step 3: Click the Header & Footer button in the Text section of the navigational ribbon.

click the header and footer button

 

 

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.

click on the header once to select it

 

 

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.

manually decrease the size of the page margin

 

 

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.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.