How to Repeat Rows in Excel 2010

Microsoft Excel has a lot of different ways that you can customize your spreadsheets. However, many of these options are centered around enhancing the experience for users that are looking at spreadsheets on the computer. This is not to say that Excel doesn’t have a number of helpful methods for improving printed documents, however. There are many ways to customize the margins, orientation and size of the data that you want to print in Excel to improve the readability of the sheet when it is printed on paper. But multi-page documents suffer from an additional problem where someone viewing the printed spreadsheet may have difficulty tracking the column that a piece of data belongs to. You can overcome this problem by learning how to repeat a row at the top of each page in Excel 2010.

 

How to Repeat Rows in Excel 2010 When Printing

 

Repeating a row on each page of a spreadsheet in Excel 2010 is dependent upon your use of column headings for your sheet. While typical usage involves these headings being located in the first row of the spreadsheet, you can specify any row to repeat at the top of your sheets, if you so choose.

Begin the process of learning how to repeat rows in Excel 2010 by opening your spreadsheet in Excel 2010. You can either launch Excel 2010, then use the Open command on the File tab, or you can simply double-click the file in Windows Explorer to automatically open the file in Excel 2010.

Click the Page Layout tab at the top of the window, then click the Page Setup button at the bottom-right corner of the Page Setup section on the ribbon.

open the page setup window to repeat rows in excel 2010

 

This opens the Page Setup window above your Excel 2010 spreadsheet. You will note that there are a lot of helpful other options on this screen for improving the display and layout of your document, such as page orientations, margins, headers and footers, as well as the Sheet tab, on which you can click the Gridlines option to print the gridlines with your spreadsheet. But for the purpose of repeating a row at the top of each page in Excel 2010, we need to use a different option on the Sheet tab.

Click inside the Rows to repeat at top field at the center of the window, then click the row that you want to repeat at the top of each page. For example, in the image below I am going to repeat the first row at the top of each page. So I clicked the row label for row 1, which entered $1:$1 into the Rows to repeat at top field.

how to repeat rows in excel 2010

 

Once the correct value is being display in that field, click the OK button to apply that setting. You can now press Ctrl + P on your keyboard to open the Print window. If you cycle through your pages in the Print Preview section of the page, you will note that the row that you selected is now being displayed at the top of each page.

Share this...Share on FacebookTweet about this on TwitterShare on Google+Pin on PinterestShare on TumblrShare on RedditEmail this to someone