How to Change or Edit an Existing Header in Excel 2013

The header section of an Excel spreadsheet is a great place to add a page number, or include important information that can help to identify the printed sheet.

But if you have a worksheet that you update periodically, you might find that the information currently contained within the header is no longer accurate and that you need to edit it.

Fortunately, the header in Excel 2013 is an editable region of the document, and it can be modified in a manner similar to how it was originally created.

Our guide below will walk you through the steps needed to change or edit an existing header in an Excel spreadsheet.

How to Add, Remove, or Change Information in the Header of an Excel 2013 Worksheet

The steps below will assume that you have an existing Excel 2013 spreadsheet, and that you would like to modify some of the information contained within the header of that worksheet.

We will be changing an existing title in the header with the guide below, but the principle is the same for other types of edits as well.

Step 1: Open the worksheet 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 ribbon.

click the header and footer button

Step 4: Click inside the Header field at the top of the spreadsheet.

click inside the header field

Step 5: Edit the existing header as needed.

how to change or edit an existing header in excel 2013

You can then click any of the cells on the spreadsheet to exit the Header and Footer editing mode.

Now that you know how to edit an existing header in an Excel 2013 spreadsheet you will be able to fix incorrect information or more information that you want to include on every sheet.

Read this article to see how to return to normal view in Excel 2013 once you have finished editing the header.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy