Top Nav

How to Print Header Rows in Excel 2016

Finding out how to print header rows in Excel is one of those things that you’d think would be simple and obvious, but it’s not. It is simple—it only takes about two clicks to print headers in Excel—but they bury the feature on the last tab on the Page Setup dialog.

I’ll show you where it is.

Note: These steps were written for Excel 2016, but they should work for earlier versions (Excel 2007, Excel 2013, etc.)

Printing One or More Header Rows or Columns in Excel

Similar to how you can freeze the first row or first column in the View tab, you can print out the first row or first column (or more) on each page of your spreadsheet. This works with data formatted as a table, too.

To do this, it doesn’t matter if you have your panes frozen or not.

  1. Go to the Page Layout ribbon.
  2. Click Print Titles.

  3. Look for the option “Rows to repeat at top.”
  4. Click the little up arrow () to the right.

  5. Your cursor will turn into a little arrow pointing to the right.
  6. Click the row you want to repeat. Note it doesn’t have to be the top row. To select more than one row, you can click and drag or hold <CTRL> and click.

  7. Once you’re satisfied, press <ENTER>.
  8. That’s it. To make sure it looks OK, click Print Preview and scroll to the 2nd page.

If you want to do the same thing with columns, do the steps above but enter columns into “Columns to repeat at left.”

Got questions or comments about Excel? Leave a comment or shoot me an email!

More Reading:

,

2 Responses to How to Print Header Rows in Excel 2016

  1. Dr Abdul Rasheed April 8, 2017 at 7:47 pm #

    Does not work with office 2013

    • Jack Busch April 9, 2017 at 5:23 pm #

      What happens if you try? Make sure you aren’t editing a cell or have a chart selected. I did this on Excel 2013 and didn’t have issues

Leave a Reply

 

Free Learning

 

Don't miss a single tip, how to or tech news update. Subscribe to my free newsletter and receive updates, right to your inbox.

You have Successfully Subscribed!

6 Shares
Share4
+11
Share1
Buffer
WhatsApp