In excel 2016 how do I repeat the top row(s) on the print out?

To have the first (or any) row repeat at the top of every printed page in Excel 2016, do the following:

1. Go to the Page Layout tab on the ribbon.
2. In the “Page Setup” group, click Print Titles.
3. In the Page Setup dialog that appears, click the Sheet tab.
4. In the Rows to repeat at top field, enter the row reference you want to repeat.

• For example, to repeat just row 1, type:
  $1:$1
• Or click the collapse-dialog button at the right of that box, then select row 1 on the sheet.

1. Click OK.

Now when you print (File → Print or Ctrl+P), row 1 will appear at the top of every page.