Excel 2013 offers a number of different options for organizing your data, but many of them are most effective when you are viewing or editing the data on your computer screen. Much of this organization does not carry over to the printed page, and you will find that you need to experiment with different settings until you achieve a good printout of your data. one element of printing in Excel that is problematic for many people is identifying the correct rows and columns on pages beyond the first.
Most Excel creators will include a row of labels at the top of their spreadsheet. This row will print on the first page by default, but will not be included on the 2nd, 3rd, 4th, etc. pages by default. Our guide below will show you the change to make to your spreadsheet so that you can repeat a row at the top of every page of your spreadsheet.
Print the Headings at the Top of Every Printed Page in Excel 2013
The steps in this article will show you how to repeat a single row at the top of every page in your spreadsheet. This row will only appear when you go to print the sheet; it will not be visible when you are editing the worksheet in the Normal view mode in Excel 2013.
Step 1: Open your worksheet 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 horizontal navigation ribbon.
Step 4: Click inside the Rows to repeat at top field.
Step 5: Click the row number to the left of the row that you wish to print at the top of every page. You can also choose to hold down the mouse button as you click on the row number, then click additional row numbers if you want to repeat more than one row at the top of every page of your Excel spreadsheet.
Step 6: Click the OK button at the bottom of the window.
Now you can click File -> Print to open the Print menu. If you scroll through the pages in your Print Preview, you should notice that the row you just selected is repeated at the top of every page.