How to Repeat a Row at the Top Of Every Page in Excel 2013

Printing the same row at the top of every page in an Excel spreadsheet provides a simple way for people to know what type of data they are reading once they progress beyond the first page. You may have previously tried to do this manually, which can be remarkable frustrating if you need to delete, add, or other wise reorganize data. Fortunately it is a setting that Excel 2013 allows you to apply automatically.

Step 1: Open your spreadsheet in Excel 2013.


Step 2: Click the Page Layout tab at the top of the window.

how to include a row at the top of the page in excel


Step 3: Click the Print Titles button in the Page Setup section of the ribbon.

how to automatically print the same row at the top of every page in excel


Step 4: Click inside the Rows to repeat at top field, then click the row number containing the cells that you wish to repeat at the top of every page.

how to repeat the top row on every page in excel 2013


Step 5: Click the OK button at the bottom of the Page Setup window to save your changes.