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 remarkably frustrating if you need to delete, add, or otherwise reorganize data.

Fortunately, it is a setting that Excel 2013 allows you to apply automatically.

You can learn about another setting that’s helpful when you’re trying to print a spreadsheet. Our how to fit all columns on one page in Excel tutorial can make it much easier to fit your data on the printed page.

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.

Now that you know how to repeat a row at the top of every page in Excel 2013, you can make it much easier for people to identify data in your cells and columns.

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy