Excel Tip: Place Column and Row Titles on Multiple Pages
First, choose file, Page Setup from the menus, and click on the Sheet tab.
To assign rows that will repeat at the top of each page:
Click in the Print titles area of the Page Setup/Sheet screen.
Click on the row number of the row from your worksheet that contains the column titles that should repeat. You can drag through multiple row numbers if your titles fill more than one row.
To assign columns that will repeat at the left of each page:
1. Click in the Columns to repeat at left area of the Page Setup/Sheet screen.
2. Click on the column letters for the columns that contain the titles that you want to repeat on your worksheet.
Click OK when all titles have been set.