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.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.