You can specify that a particular row(s) or column(s) appear as titles on each page of your worksheet. If you select a row, it is printed at the top of each page. If you select a column, it is printed at the left edge of each page. You can select multiple rows or columns, but they must be adjacent.
You cannot select both rows and columns to be print titles. It must be either rows or columns.
Print titles may be separate ranges from print areas or they may overlap. No matter what size or shape the print area, if you set print titles, the print title cells will appear above or to the left of the print area cells.
You can have the worksheet row and column headings (that is, the gray boxes that contain the row and column letters and numbers) appear as titles on printed copies by changing the settings in the Sheet Print Options dialog box. For information, see Specifying Sheet Print Options.
To set print titles:
The print titles are set.
To remove previously set print titles:
No titles will appear on any printouts.