How to Repeat Header Rows in Excel

1. Launch Microsoft Excel and open the worksheet that you want to use.
2. Click the 'Page Layout' tab, and then click 'Print Titles' in the Page Setup group. The Page Setup window opens displaying the Sheet tab.
3. Click the 'Collapse Dialog' button in the 'Rows to Repeat at Top' box.
4. Select the row that contains the header you want to repeat, and then click the 'Collapse Dialog' button. The row reference automatically populates the 'Rows to Repeat at Top' box. Click 'OK' to save the settings.