Excel can print the workbook’s file name on every page by placing the file-name field in a header or footer. Because it is a field rather than manually typed text, it can reflect the workbook’s saved file name when printed.
Add the file name to every printed page
- Open the workbook in desktop Excel.
- Select the worksheet you want to configure.
- Open Page Layout and launch the Page Setup dialog.
- Select the Header/Footer tab.
- Choose a built-in header or footer containing the file name, or open the custom header/footer editor.
- Insert the File Name field in the left, center, or right section.
- Use Print Preview to confirm that it appears on each page.
Apply it to more than one worksheet
Header and footer settings belong to worksheets. If several sheets need the same printed file name, group the intended worksheets before applying the setting, then ungroup them afterward so later edits do not accidentally affect every selected sheet.
The file name and file path are separate fields. Use the file-name field when you only want the workbook name; use the path field when printed pages also need to identify where the workbook was stored.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.