Go to the Page Layout tab
Click Print Titles
In the Page Setup dialog, open the Sheet tab
Click the Rows to repeat at top box
Select the header row you want repeated
Click OK
Print or preview the sheet to confirm the header repeats on each page
Go to the Page Layout tab
Click Print Titles
In the Page Setup dialog, open the Sheet tab
Click the Rows to repeat at top box
Select the header row you want repeated
Click OK
Print or preview the sheet to confirm the header repeats on each page