• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • Product ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
Techwalla
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Repeat Header Rows in Excel

How to Repeat Header Rows in Excel

March 31, 2015
By: C. Taylor
  • Share
  • Share on Facebook

Complicated Excel spreadsheets can span multiple printed pages, and without labels accompanying the data, the printout is often confusing. By default, Excel 2013 does not repeat data headers, which means subsequent pages present only the data without labels. Furthermore, Excel doesn't include the inherent column letters or row numbers in printouts. However, you can configure Excel's Print Titles settings to repeat your configured headers and optionally include Excel's column and row labels on every printed page, so you always know what data you're viewing.

Video of the Day

Young man at office desk, working on laptop
credit: AnaBGD/iStock/Getty Images

Printing Headers on Each Page

Exit any cell that you're currently editing and ensure you don't have multiple sheets selected; either scenario will cause problems in the procedure. Click the "Page Layout" tab and then select "Print Titles" in the Page Setup group. Enter the rows you want to repeat in the "Rows to Repeat at Top" field using the format "$A:$A," or click the "Collapse Dialog" button to select the appropriate rows with your mouse. Enter the columns you want repeated in the "Columns to Repeat at Left" field. These options repeat the data header labels you selected. If you also want to include the column letters and row numbers, check "Row and Column Headers" in the Print section. Click "OK" to apply your selections.

Show Comments

Related Articles

How to Add an Appendix to a Word Document

How to Add an Appendix to a Word Document

Around The Home
Productivity
By: James T Wood
How to Set "Do Not Print Cell" in Excel

How to Set "Do Not Print Cell" in Excel

Around The Home
Productivity
By: Harjinder Singh
What Is a Tabular Format?

What Is a Tabular Format?

Around The Home
Productivity
By: David Sarokin
How to Print Address Labels in Excel

How to Print Address Labels in Excel

Around The Home
Productivity
By: Scott Shpak
How to Create HTML Email in Dreamweaver

How to Create HTML Email in Dreamweaver

Around The Home
Productivity
By: Steve McDonnell
Elements of MS Excel

Elements of MS Excel

Around The Home
Productivity
By: Lisa Bass
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2018 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.