Print column headers or spreadsheet labels on every page

Excel 2016
If you want to print a spreadsheet with data on several pages, it is more informative to have column headers or labels on every printed page. See also how to print a large Excel spreadsheet.

For example, when you print an Excel spreadsheet on several pages, you can't see column headers or labels on the second and following pages:

Print preview on two pages in Excel 365

To print column headers or labels on every page, do the following:

   1.   On the Page Layout tab, in the Page Setup group, click Print Titles:

Print Titles button in Excel 365

   2.   In the Page Setup dialog box, on the Sheet tab, in the Print titles section:

Print Setup in Excel 365
  • choose rows you want to print on every page in the Rows to repeat at top field;
  • choose columns you want to print on every page in the Columns to repeat at left field.

For example, for the selected rows $1:$4 you will get:

Print Rows at top of every page in Excel 365

Notes:

  • If you want to print row and column labels, you can check the Row and column headings checkbox:
    Page Setup Row and column headings in Excel 365

    For example:

    Print preview Row and column labels in Excel 365
  • If you want to print Gridlines, you can check the Gridlines checkbox, for example:
    Print preview Gridlines in Excel 365

See also this tip in French: Imprimer des en-têtes de colonnes ou des étiquettes de feuille de calcul sur chaque page.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.