• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Excel / How to Repeat the File Name on Every Page in Excel for Office 365

How to Repeat the File Name on Every Page in Excel for Office 365

June 21, 2019 By Matt Jacobs

A printed spreadsheet is a difficult thing to customize properly. Whether you need lines between cells, you need it centered on the page, or you need to repeat a row on every page, there are a lot of options to consider.

But perhaps one of the biggest challenge when printing in Excel is ensuring that multi-page spreadsheets are easy to identify should the pages become separated. A lot of spreadsheets look very similar to one another, and a rogue page of one of those spreadsheets could be difficult to identify. Our guide below will show you how to include your Excel file name at the top of every page to help solve this problem.

How to Include the Filename in the Header or Footer in Excel

The steps in this article were performed in Microsoft Excel for Office 365, but will work in most recent versions of Excel as well. I am going to be adding the filename to the header in the steps below, but the process is nearly identical if you want to add the filename to the footer.

Step 1: Open your file in Excel.

Step 2: Choose the Page Layout tab.

select the page layout tab

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

click the page setup button

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

choose the header and footer tab

Step 5: Click the Custom Header or Custom Footer button, depending on where you want to place the filename.

select the custom header or custom footer

Step 6: Click inside the part of the header or footer where you want the filename, then click the Insert File Name button.

how to add a filename to each page in excel

Step 7: Click the OK button on each of the open windows to close them and return to the spreadsheet.

file name has been added to header in excel

Find out how to repeat the top row of your spreadsheet on every page if you have a row of headers that make it easier to identify the data in your cells.

Matt Jacobs

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.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Show Contact Photos in Messages on an iPhone 11
  • How to Sign Out of Spotify on an iPhone
  • How to Flip a Picture in a Microsoft Word Document
  • How to Announce Messages with Siri on an iPhone 11
  • How to Clear Spotify Cache on an iPhone

Featured Posts

Why is the Text Bold on My iPhone 11?

How to Change the Paper Size in Microsoft Word for Office 365

How to Uninstall an App on the Amazon Fire TV Stick

How to Turn Off Camera Permissions for Pokemon Go on an iPhone

how to add or remove the phone symbol on iPhone

How to Remove the Phone Symbol on an iPhone

How to Remove Columns in Google Docs

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com