If you often print your work in Excel, you would benefit from knowing how to make sure a row (or multiple rows) print on every page that you print.
This is often needed as you want the data row headers to be visible so that it’s easier to know what a data point represents.
Thankfully, there is an in-built feature in Excel that allows you to set a row to print on every page (or set a column to print on every page).
In this tutorial, I will show you all the steps you need to do set the headers to show up on every printed page.
How to Set a Row to Print on Every Page in Excel
Suppose you have a dataset as shown below where there are hundreds of rows of data with the header in the first row.
If you print this data in the current form, you will only get the header on the first page and rest all the page will have only the data and not the headers.
Below are the steps to make sure the headers repeat on every printed page:
- Click on the Page Layout option in the ribbon
- In the Page Setup group, click on the ‘Print Titles’ option. This will open the ‘Page Setup’ dialog box
- In the Page Setup dialog box, click on the cell selector icon (upward arrow) for the ‘Rows to repeat at top’ option
- In the dataset, select the header cells (you can also select the entire row if you want)
- Click OK
Now, when you print the data, you will have the selected header row cells repeat on every page.
You can use the same steps to also repeat multiple rows on each page (in case your headers occupy more than one row), as well as repeat one or more than one column on each page.
Note: It’s best to check the print preview before printing the worksheet. The print preview will show you exactly what will be printed on each sheet. To do this, click on the ‘File’ tab and then click on ‘Print’.
Also, it’s not necessary to always have the rows that you want to repeat at the top. For example, if you want to repeat row numbers 4 and 5, you can select these rows in step 4. Now, when Excel is printing your data, it will print the first page as expected, and from the second page onwards, it will have row #4 and #5 at the top, which will repeat on all pages.
I hope you found this Excel tutorial useful.
You may also like the following Excel tutorials: