• 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 / Printing / How to Repeat a Row at the Top Of Every Page in Excel 2013

How to Repeat a Row at the Top Of Every Page in Excel 2013

February 1, 2017 By Matt Jacobs

Printing the same row at the top of every page in an Excel spreadsheet provides a simple way for people to know what type of data they are reading once they progress beyond the first page. You may have previously tried to do this manually, which can be remarkable frustrating if you need to delete, add, or other wise reorganize data. Fortunately it is a setting that Excel 2013 allows you to apply automatically.

Step 1: Open your spreadsheet in Excel 2013.

 

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

how to include a row at the top of the page in excel

 

Step 3: Click the Print Titles button in the Page Setup section of the ribbon.

how to automatically print the same row at the top of every page in excel

 

Step 4: Click inside the Rows to repeat at top field, then click the row number containing the cells that you wish to repeat at the top of every page.

how to repeat the top row on every page in excel 2013

 

Step 5: Click the OK button at the bottom of the Page Setup window to save your changes.

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

How to Stop the Screen from Sliding Down on an iPhone 7 Plus

how to remove highlight in Google Docs

How to Remove Highlight in Google Docs

how to have Siri announce messages on an iPhone

How to Announce Messages with Siri on an iPhone 11

How to Remove Gridlines in Microsoft Word for Office 365

How to Save a Single Slide as a Picture in Google Slides

How to Find Out How Many Pokemon You’ve Caught in Pokemon Go

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