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.

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

birthday t-shirts for boys
vintage t rex t-shirt