Start by selecting the page layout tab and then open the Page Layout dialog box.
On the Sheet tab of the Page Setup dialog box, click on the rows to repeat at top.
Clicking on the row you want to appear at the top of each page will populate the Page Setup – Rows to repeat at top dialog box. When done return to the Page Setup dialog box by hitting the enter key.
Select the OK button to complete the setup.
Now whenever you print preview or print your worksheet, the row you selected will be repeated at the top of each page.