If your worksheet contains multiple pages, you will see header rows or columns only printed in the first page by default. In this article, we are going to show you how to print header row in Excel to repeat on every printed page in Excel 2016, Excel 2013, Excel 2010 and Excel 2007.
By default, Excel does not print the headings of tables. You need to activate this feature from the Page Setup options. There are 2 ways to open the Page Setup window.
- From the top Ribbon
- From the Print window, just before printing
Let’s see these two methods more in detail.
When working on your workbook, begin by going into the Page Layout tab in the Ribbon. Then, click on the Print Titles icon to open the Page Setup dialog. The Sheet tab will already active. This menu contains the options to print header row in Excel to repeat on every printed page.
Page Setup dialog
The other option is a little longer than the Ribbon approach. First, open the Print page and go to the Page Setup window. You can access the Print page using one the following:
- Follow the File > Print path in the Ribbon
- Press Ctrl + P
- Press Ctrl + F2
On the Print window, click the Page Setup link to open the Page Setup dialog. You can find the link at the end of the Settings section.
Once the dialog is open, go to the Sheet tab. You will see two reference inputs under the Print titles section.
Regardless of how you get to this step, you will need to be on the Sheet tab in the Page Setup dialog.
Click the reference selector icon corresponding to the heading type you want to be repeated. For example, to print the header row on each page, click the button and select the header row reference. In the example below, we set Rows to repeat at top to 2nd row to repeat. If you want to repeat a column or columns, use the Columns to repeat at left option.
Click OK to save your settings. From now on, every printed page will start with header row. You can remove the reference to take your changes back.