Repeat rows on top when printing, show headers on every page

We have all been there; you have a worksheet that you need to print. However the worksheet is more than one printed page in length and you would like to have the header row printed at the top of each printed page.

Well Excel allows you to easily do this. When you are on the tab that you want to print, Select Page Layout > then select Page Setup.

This brings up the Page Setup Dialog Window.

Select the Sheet Tab and then fill in the rows to repeat at the top. If you click on the rows to repeat at the top then click on cell A1, Excel will automatically fill in the row for you ($1:$1).

You can also choose to repeat columns to the left using this dialog window.