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:
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:
The Page Setup menu would appear on your screen:
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):
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).
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.
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:
Once you’re ready, click on Print and you should be good to go.