How to Repeat Headers on Every Page when Printing in Excel

Follow these simple steps to repeat headers when printing from Excel:

Step 1

Click on the Page Layout menu and then the Print Titles button.

Step 2

After clicking on Print Titles a dialogue window will open. Now simply click on the row you would like to repeat on each page.

in Microsoft Excel Tags: Repeat Titles in Excel
Did this article answer your question?