How to Set a Row to Print on Every Page in Excel

by

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:

  1. Click on the Page Layout option in the ribbonClick the Page Layout tab
  2. In the Page Setup group, click on the ‘Print Titles’ option. This will open the ‘Page Setup’ dialog boxClick on Print Titles
  3. In the Page Setup dialog box, click on the cell selector icon (upward arrow) for the ‘Rows to repeat at top’ optionClick on the option to select the row that you want to repeat on each page in Excel
  4. In the dataset, select the header cells (you can also select the entire row if you want)Select the row that you want to repeat
  5. 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.

Advanced Concept: When you specify the rows/columns to repeat, Excel creates a named range with the name Print_Titles. This named range holds the range that Excel needs to repeat on each page. So even if you close the workbook and open later, Excel would remember what rows/columns need to be repeated.

I hope you found this Excel tutorial useful.

You may also like the following Excel tutorials:

Leave a Comment