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 –
- Open the worksheet in Excel 2013.
- Click the Page Layout tab at the top of the window.
- Click the Page Setup button at the bottom-right corner of the Page Setup section in the ribbon.
- Click the Header/Footer tab at the top of the window.
- Click the Custom Header button.
- 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.
Step 3: Click the Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.
Step 4: Click the Header/Footer tab at the top of the window.
Step 5: Click the Custom Header button at the center of the window.
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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.