Open the File menu and select Page Setup; then select the Sheet tab on the Page Setup dialog box.
Click the Rows to Repeat at Top selection box in the Print Titles area. Excel shrinks the Page Setup dialog box, making your focus the worksheet on your desktop.
Select the row(s) containing the titles you want to repeat on each page of your worksheet; then press Enter to reopen the Page Setup dialog box with your selection.
Click OK. If you want, you can view the worksheet in Print Preview mode to get an idea of what your printed worksheet will look like with repeating row headings.
INTRODUCTION
You might have noticed that, when a worksheet spans multiple pages, keeping the column and row titles organized is difficult. A quick way to rectify this is to make particular titles repeat on each page of the printed worksheet. In this task, you'll learn how to make row headers repeat.
TIP
Repeating Titles in Print Preview Mode
You cannot assign repeating titles while you are in Print Preview mode; you must be in the worksheet view and select File, Page Setup.
TIP
Repeating Column Headings
To repeat column headings across several pages, follow the steps in this task, but click the Columns to Repeat at Left selection box in step 2. Then, click the columns you want to repeat and proceed as normal.