Print row and column headings in Excel 2016 for Mac

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:

Worksheet showing position of headings and titles

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

  1. Click the sheet.

  2. On the Page Layout tab, under Headings, select the Print check box.

    On the Page Layout tab, under Headings, select Print

  3. On the File menu, click Print.

Print column titles on every page

  1. Click the sheet.

  2. On the Page Layout tab, select Page Setup, and then select the Sheet tab.

  3. 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.

    Page Setup dialog box with repeated rows specified

    Tip: To minimize and expand the Page Setup dialog box so that you can see more of your sheet, click Collapse Dialog Box button image or Expand button next to the box that you clicked in.

  4. Click OK.

  5. On the File menu, click Print.

Print row titles on every page

  1. Click the sheet.

  2. On the Page Layout tab, select Print Titles, and then select the Sheet tab.

  3. Click in the Columns to repeat at left box, and select the column in your worksheet that contains the row titles.

    Page Setup dialog box with repeated columns specified

    Tip: To minimize and expand the Page Setup dialog box so that you can see more of your sheet, click Collapse Dialog Box button image or Expand button next to the box that you clicked in.

  4. Click OK.

  5. On the File menu, click Print.

See Also

Print a sheet or workbook

Scale the sheet size for printing

Print a sheet on just one page

Print cell gridlines

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×