How to repeat headers on every page when printing in Excel
Follow these simple steps to repeat headers when printing from Excel:
Click on the Page Layout menu and then the Print Titles button.
After clicking on Print Titles a dialogue window will open. Now simply click on the row you would like to repeat on each page.