How to print specific rows or columns in Excel 2007

If a worksheet spans more than one page, you can print row and column headings or labels (also called print titles) on every page to ensure that the data is properly labeled.

1. Select the worksheet that you want to print.
2. On the Page Layout tab, in the Page Setup group, click Print Titles.

 NOTE   The Print Titles command will appear dimmed if you are in cell editing mode, if a chart is selected on the same worksheet, or if you don’t have a printer installed. 

3. On the Sheet tab, under Print titles, do one or both of the following:
• In the Rows to repeat at top box, type the reference of the rows that contain the column labels.
• In the Columns to repeat at left box, type the reference of the columns that contain the row labels.

For example, if you want to print column labels at the top of every printed page, you could type $1:$1 in the Rows to repeat at top box.

 TIP   You can also click the Collapse Dialog button  at the right end of the Rows to repeat at top and Columns to repeat at left boxes, and then select the title rows or columns that you want to repeat in the worksheet. After you finish selecting the title rows or columns, click the Collapse Dialog button  again to return to the dialog box.

Original Link
© 2012 Microsoft Corporation