Microsoft Office Tutorials and References
In Depth Information
Getting Ready to Print a Worksheet
4. Select the row or column with the labels or names you need.
As long as they’re next to each other, you can select more than one row
or column by dragging over the row numbers or column letters.
5. Click the Range Selector button to enlarge the dialog box and see it
The text box now lists a cell range address.
6. Repeat Steps 3 through 5 to select column or row headings.
7. Click OK to close the Page Setup dialog box.
If I were you, I would click the Print Preview button in the Page Setup
dialog box first to make sure that row and column headings are indeed
repeating from page to page.
To remove row and column headings, return to the Sheet tab of the Page
Setup dialog box and delete the cell references in the Rows to Repeat at
Top text box and the Columns to Repeat at Left text box. You can also press
Ctrl+F3 and delete Print_Titles in the Name Manager dialog box.