If you have an Excel sheet that prints on more than one page, it is helpful if the titles print at the top of each page, not just on page one.

Unfortunately you cannot set this feature up from Print Preview.

For Excel 97 – 2003:

1. File, Page Set Up, then the Sheet Tab.
   
2. At Rows to repeat at top, click the red marker at the end of the area then click on the row # (#’s) you want to repeat at the top, then press Enter.  You can then select Print Preview from this box to see how it works.

For Excel 2007:

1. Click on the Page Layout Ribbon, then in the Page Setup group, select the Print Titles icon.
2. The dialog box above in the 97-2003 instructions appears.  Follow the step 2 above.

NOTE:  You can also repeat columns on the left of a printed page.  This is helpful is the data will not print one page wide.