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.
- Go to the Page Layout ribbon.
- Click Print Titles.
- Look for the option “Rows to repeat at top.”
- Click the little up arrow () to the right.
- Your cursor will turn into a little arrow pointing to the right.
- 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.
- Once you’re satisfied, press <ENTER>.
- 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!