If you want to print a sheet that will have many printed pages, you can set options to print the headings or titles. What's the difference between "headings" and "titles"?
Row and column headings are what Excel automatically provides for columns (A, B, C) and rows (1, 2, 3). In the following illustration, for example, A and 1 are headings:
You type titles in your sheet that describe the content in rows and columns. In the above illustration, for example, Projected is a row title and 2nd QTR is a column title. People often refer to titles as "headers," or "labels," but Excel calls these titles nonetheless.
Print row and column headings
-
Click the sheet.
-
On the Page Layout tab, under Headings, select the Print check box.
-
On the File menu, click Print.
Print column titles on every page
-
Click the sheet.
-
On the Page Layout tab, select Page Setup, and then select the Sheet tab.
-
Under Print Titles, click in the Rows to repeat at top box, and then on the sheet, select the row that contains the column titles.
Tip: To minimize and expand the Page Setup dialog box so that you can see more of your sheet, click
or
next to the box that you clicked in. -
Click OK.
-
On the File menu, click Print.
Print row titles on every page
-
Click the sheet.
-
On the Page Layout tab, select Print Titles, and then select the Sheet tab.
-
Click in the Columns to repeat at left box, and select the column in your worksheet that contains the row titles.
Tip: To minimize and expand the Page Setup dialog box so that you can see more of your sheet, click
or
next to the box that you clicked in. -
Click OK.
-
On the File menu, click Print.
