How Do I Repeat Headers on Every Page In Excel?

1. Open the Excel spreadsheet that you want to print with repeating headings.
2. Click the 'Page Layout' tab on the ribbon.
3. Click the 'Print Titles' button in the Page Setup group. This will open a window with several tabs. Select the 'Sheet' tab if it is not already open.
4. Click the little blue icon with a red arrow at the far right of the box called 'Rows to repeat at the top.' This will bring up a narrow window with a blank line. Click the row in your spreadsheet that you want repeated. Usually this is the first row with column headings. To select several rows, click and drag down until you see all the rows you want, highlighted. This will insert the row numbers into the narrow box.
5. Click the little icon on the far right of the box to insert the row numbers into the printing window.
6. Click 'Print Preview' to see how the headings will look on multiple pages. Click 'Print' if you are satisfied.