How to Use the Print Titles Feature in Excel 2013
Click the Print Titles button on the Ribbon’s Page Layout tab or press Alt+PI.
The Page Setup dialog box appears with the Sheet tab selected.
To designate worksheet rows as print titles, go to Step 2. To designate worksheet columns as print titles, go to Step 3.