Excel

1. Click on page layout Ribbon.
2. In the Page Set up section click on Print titles
3. Where it says "rows to repeat at the top" click on the icon containing a red arrow.
4. Click on the row you want to repeat on each print out.
5. Now click on the same icon containing the red arrow.
6. This returns you back to the window box, now click on OK.

Job done :)