How to Display The Top Row on Every Page in Excel 2010

While it would be nice to only work with Microsoft Excel 2010 on a computer, it’s probable that the spreadsheets you create in that program will have to be printed out for someone. There aren’t really any foreseeable problems with the situation when dealing with a single page spreadsheet, but multiple page spreadsheets can be tricky when they’re printed on paper, specifically if the spreadsheet has a lot of columns. To simplify the experience for your spreadsheet readers, consider setting your page options to display the top row, with all of your column labels, at the top of every spreadsheet page. That way they won’t be confused about which column contains what data, thereby preventing them from needlessly going back to the first page of the spreadsheet and matching up columns.


Step 1: Click the “Page Layout” tab at the top of Excel 2010.

Excel 2010 page setup tab


Step 2: Click the small box to the right of “Page Setup” in the ribbon at the top of the window.

Open the Page Setup menu


Step 3: Click the “Sheet” tab at the top of the “Page Setup” pop-up window.

Click the Sheet tab


Step 4: Click inside the empty field to the right of “Rows to repeat at top,” then click the row number that you want to repeat at the left side of the window. In the example picture below, for example, I am repeating row “1.”

Select the row to repeat at the top of your Excel spreadsheet


Step 5: Click the “OK” button at the bottom of the pop-up window to apply your changes.


When you print out your spreadsheet after this, then row that you selected in step 4 will me at the top of every printed page. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.