Repeat Specific Rows on Every Printed Page in Excel

In this quick guide, I’ll show you the steps to repeat specific rows on every page when printing in Excel.

The Example

Let’s say that you have a list of 60 employees in Excel. This list contains the following column names:

  • Employee First Name
  • Employee Last Name

Your goal is to print those two column names on every page in Excel.

Here is how the dataset would look like in Excel:

Sample data

Steps to Repeat Specific Rows on every Printed Page in Excel

To start, go to the Page Layout tab, and then press on Print Titles:

Print Titles

The Page Setup menu would appear on your screen:

Repeat Specific Rows on Every Printed Page in Excel

First, click inside the Rows to repeat at top box. Then, press anywhere on the first row of your excel spreadsheet (as this is the row to be repeated on every printed page in Excel):

Repeat Specific Rows on Every Printed Page in Excel

Now, this is how your Page Setup menu would look like (i.e., the “Rows to repeat at top” box will now contain the value of $1:$1 which represents the first row to be repeated).

Repeat Specific Rows on Every Printed Page in Excel

Once you’re done, press OK, and your first row will now get repeated across all pages.

Printing your List

You can now print your list by pressing Ctrl+P on your keyboard.

You’ll then see a preview of the pages to be printed.

As you can see below, the first row (containing the “Employee First Name” and the “Employee Last Name”) appears at the top of the first page to be printed.

Repeat Specific Rows on Every Printed Page in Excel

But what about your second page?

Similarly, if you navigate to the second page to be printed, you’ll see the first row repeated at the top of the second page as well:

Printing

Once you’re ready, click on Print and you should be good to go.