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.
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.
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.
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.
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.
We welcome your comments and questions about this lesson. We don't welcome spam. Our readers get a lot of value out of the comments and answers on our lessons and spam hurts that experience. Our spam filter is pretty good at stopping bots from posting spam, and our admins are quick to delete spam that does get through. We know that bots don't read messages like this, but there are people out there who manually post spam. I repeat - we delete all spam, and if we see repeated posts from a given IP address, we'll block the IP address. So don't waste your time, or ours. One other point to note - if you post a link in your comment, it will automatically be deleted.