Setting Print Titles

Often it is helpful to repeat a certain number of rows at the top of the your worksheet printout, or a certain number of columns at the left of the printout. This is particularly useful if you are using the rows or columns as titles for the information in your worksheet. To set print titles, follow these steps:

1. Select the worksheet whose titles you want to set.
2. Display the Page Setup dialog box. (Choose Page Setup from the File menu or, if you are using excel 2007, display the Page Layout tab of the ribbon and then click the small icon at the lower-right of the Page Setup group.)
3. Make sure the Sheet tab is selected. (Click here to see a related figure.)
4. In the Rows to Repeat at Top field specify the rows you want to repeat (if any).
5. In the Columns to Repeat at Left field specify the columns you want to repeat (if any).
6. Click on OK.

When specifying rows or columns in steps 4 and 5, you only need to provide the row or column names (such as $1:$3 or $A:$B); actual cell coordinates are not acceptable. You can also use the mouse to specify the columns or rows to be used. First click your mouse in the field you want to set and then select the rows or columns you want repeated.

You should note that titles are not actually started until they are actually encountered when printing. Thus, if you select titles that would appear on page 3 of your printout, they will not begin repeating until page 4 is printed.