the MOST

When you need to print a spreadhseet that has too many rows to fit on one page, the information on the second page can lose meaning without the column headers.  The same thing can happen if you have more columns than can fit on a page.  Fortunately, Excel has a feature that allows you to repeat the same row and the same column on every printed page.

Excel 2007

1. Go to the Page Layout tab and click on the Print Titles button.
2. Select the Sheet tab. 
3. Click on the Rows to repeat at top box.  Then, in your spreadsheet, highlight the row or rows you would like to have repeated at the top of each page. 
4. If you have more colums than will fit on one sheet, click in the Columns to repeat at left box.  Then, in your spreadsheet, select any columns you would like to have repeated on the left.
5. Click OK.

Excel 2003

1. Go to the File menu and select Page Setup.
2. Select the Sheet tab.
3. Click on the Rows to repeat at top box.  Then, in your spreadsheet, highlight the row or rows you would like to have repeated at the top of each page. 
4. If you have more colums than will fit on one sheet, click in the Columns to repeat at left box.  Then, in your spreadsheet, select any columns you would like to have repeated on the left.
5. Click OK.