Print an Excel 2010 spreadsheet with header rows at the top of every page

When printing in Excel 2010 for Windows, it is sometimes useful to print a set of rows (e.g. column headings) on each page in the print out. There is nothing worse than having a printout that runs to multiple pages, with the column headings only printed on the first page. This lesson shows you how to get header rows printing at the top of every page.

Click here if you are looking for a lesson on how to print header rows in Excel 2011 for Mac.

Choose the rows you want to print on each page

  • Start by opening the spreadsheet you want to print.
  • In the menu, choose Page Layout. The ribbon will change to the Page Layout ribbon bar.
  • Excel Page Setup options on the Page Layout ribbon bar
  • In the Page Setup section of the Page Layout ribbon menu (see above), click Print Titles.
  • The Page Setup dialog box will be displayed as shown below. Note that there are a number of options that we won't be looking at in this lesson because they aren't relevant to what we're trying to achieve.
  • Click in the box next to Rows to repeat at top.
  • At this point you will choose which rows should repeat at the top. You have three options:
    • Type the rows you want to repeat. For example, if you want the first 4 rows to repeat, type $1:$4.
    • Click the selection box at the end of the box. The Page Setup dialog box will shrink down to just one line. You can then select the rows you want from the spreadsheet you have open.
      Selection box for rows to repeat at the top of an Excel printout
    • Just select the rows you want from the spreadsheet (assuming you can see it).
  • The last two options are essentially the same, but the last option is slightly quicker.
  • Either way, Excel will record your selection as shown below. Note the way that the rows are recorded: $1:$4. This means "print from row 1 to row 4 inclusive. In the example below, I've also selected column A to print on every page.
    Excel repeating rows at the top of a printout, with the selection made
  • The next thing you can do is click the Print Preview button to check that your selection has worked correctly. Or, you can click OK and carry on working.
  • When you print out the spreadsheet, the rows you selected will be printed at the top of each page, regardless of how many pages you print.
    • Be careful here - if your spreadsheet is more than one page wide when printed, the second page across will print what is at the top of the columns being printed.
    • If your goal was simply a title at the top of each page in the printout, you should use the Header/Footer options in the Page Setup dialog box shown earlier in this less.