Print Specific Rows or Columns on Each Page in Excel

This is a handy little tip that makes reading printed documents much easier.

Steps to Print Specific Rows/Columns on Each Page

1. Go to the Page Layout tab and click the Print Titles button:
   
2. In the window that opens, make sure you are on the Sheet tab; then, click the button to the right of where it says Rows to repeat at top:
   
   
3. Click anywhere in the row that you would like to have repeated on every page that is printed:
   
4. You should now see that row appear in the little window that is hovering over Excel; click the little box that is on the right of that window or just hit the Enter key.
   
5. You will now see the row that you selected in the window next to where it says Rows to repeat at the top: At this point, make sure it is the correct row and hit the OK button. (don't worry about the dollar signs in front of the row number, that is normal)
   
6. That's it!  Now, test it out by clicking the File button or Office button and clicking Print to go to the print preview window or just print a test page or two.  This is what each page will now look like:
   
   

To repeat columns on each page, instead of rows, in Step 2 above, click the button next to the right of where it says Columns to repeat at left: In Step 3, click the column to repeat; the rest of the steps are basically the same.

Notes

This is a really helpful feature to prepare spreadsheets for printing and it's really easy to implement.

When you save and close your document, Excel will remember the option for repeating the titles.

Make sure to download the sample file for this tutorial so you can see this feature in action.