If you want to print a sheet that will have many printed pages, you can set options to print the sheet's headings or titles on every page.
Excel automatically provides headings for columns (A, B, C) and rows (1, 2, 3). You type titles in your sheet that describe the content in rows and columns. In the following illustration, for example, Projected is a row title and 2nd QTR is a column title.
Print row and column headings
-
Select the sheet.
-
On the Page Layout tab, under Headings, select the Print check box.
-
On the File menu, select Print.
You can see how your sheet will print in the preview pane.
Print row or column titles on every page
-
Select the sheet.
-
On the Page Layout tab, select Page Setup, then the Sheets tab.
-
Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat.
-
Select OK.
-
On the File menu, select Print.
You can see how your sheet will print in the preview pane.
See also
Print with landscape orientation
