Print column headers or spreadsheet labels on every page

Excel 365
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 2016

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 2016

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

Print Setup in Excel 2016
  • 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 2016

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 2016

    For example:

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

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.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more