Excel 2013: Using the Print Titles Feature
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.