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.
Step 3: Click the Print Titles button in the Page Setup section of the ribbon.
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.
Step 5: Click the OK button at the bottom of the Page Setup window to save your changes.