How to Print a Row at the Top of Every Page in Excel 2010

Excel 2010 is a really great program for organizing and calculating data. But printing has never been something that was very easy to handle in spreadsheets, and the problem amplifies itself when you are dealing with multi-page spreadsheets that contain a lot of columns with similar-looking data.

These situations can make a printed spreadsheet difficult to comprehend, and can lead to errors where the reader mistakenly thinks that a cell of data is in a different column. One way to improve the experience for spreadsheet readers is to repeat a row at the top of every page. Simply create a row at the top of the spreadsheet that identifies the type of information that is contained within cells that are in each column, then follow our guide below to repeat that row at the top of each page.

 

Repeat the Same Row at the Top of Every Page in Excel 2010

By following the steps below, you will end up with a spreadsheet that, when printed, will repeat the same row at the top of every page. This will make it much easier for your readers to understand the information that they are looking at on each page of the spreadsheet, and it will reduce mistakes.

 

  1. Open your spreadsheet in Microsoft Excel 2010.
  2.  

  3. Click the Page Layout tab at the top of the window.
  4. click the page layout tab

     

     

  5. Click the small Page Setup: Sheet button at the bottom-right corner of the Sheet Options section in the ribbon.
  6. click the sheet options menu button

     

     

  7. Click inside the Rows to repeat at top field.
  8. click inside the rows to repeat at top field

     

     

  9. Click the row number at the left side of the spreadsheet for the row that you wish to repeat at the top of every printed page. This will populate the Rows to repeat at top field with something like $1:$1, where the number represents the number of the row that will be repeated at the top of every page.
  10. click the row number to repeat

     

     

  11. Click the OK button at the bottom of the Page Setup window to close the window and save your changes. Now, when you go to print your spreadsheet, each page should start with the selected row.

 

For additional ways to improve the Excel printing experience, you can read this article about fitting a spreadsheet on one page.