Description: This article describes how to insert the file name in an Excel 2010 header or footer.

1. To insert the file path into an Excel 2010 header or footer, click the Insert tab.

2. Click the Header & Footer button.

3. The initial input position will be in the header. Clicking the Go to Footer button will move the insert position to the footer.

4. Clicking the Go to Header button will move the insert position back into the header.

5. Once in the desired header or footer location, press the Sheet name button.

6. This will insert the code to show the sheet name on each sheet.

7. When out of the Header and Footer View the actual sheet name will be displayed.