How to Add the Filename to the Header in Excel 2013


When you have a lot of printed spreadsheets lying around your workspace, it can be difficult to determine which file a spreadsheet came from. One helpful way to solve this problem is to include identifying information in the header section of your worksheets.

An effective way to do this is by inserting the filename in the header, which you can do from the “Custom Header” window in Excel 2013. Our tutorial below will show you how to accomplish this.

 

Adding a Filename to the Header in Excel 2013

The steps in our guide below will show you how to modify the header of your Excel worksheet so that the name of the file is included at the top of the page when you print the worksheet. This method uses a variable to retrieve the filename, so it will adjust accordingly if you rename the file.

Here is how to add the filename to the header in Excel 2013 –

  1. Open the worksheet in Excel 2013.
  2. Click the Page Layout tab at the top of the window.
  3. Click the Page Setup button at the bottom-right corner of the Page Setup section in the ribbon.
  4. Click the Header/Footer tab at the top of the window.
  5. Click the Custom Header button.
  6. Select the header section where you want the filename to appear, then click the Insert File Name button. Click the OK button when you are finished.

 

These steps are shown below with pictures –

Step 1: Open your worksheet in Excel 2013.

 

Step 2: Click the Page Layout tab at the top of the window.

click the page layout tab

 

 

Step 3: Click the Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.

click the page setup dialog launcher

 

 

Step 4: Click the Header/Footer tab at the top of the window.

click the header footer tab

 

 

Step 5: Click the Custom Header button at the center of the window.

click the custom header button

 

 

Step 6: Click inside the header section where you want the file name to appear, then click the Insert File Name button. This will add &[File] text to the header section. You can then click the OK button to save and apply your changes.

add a file name to the header in excel 2013

 

 

Learn how to include the same row at the top of every page in Excel 2013 and make printed multiple-page spreadsheets easier to understand.

solveyourtech.com newsletter
vintage t rex t-shirt

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