Do you need to repeat specific rows on every page when printing in Excel? If so, in this post, I’ll show you how to select specific rows to be displayed on every printed page in Excel 2010.
To start, let’s take an example where you store a list of 60 employees in Excel. This list contains the:
- Employee First Name
- Employee Last Name
Now suppose that your boss asked you to print that Excel list with the names of those 60 employees.
Since in some cases, a list with 60 rows may not fit into a standard-size page when printing, you may want to make sure that the first row, which usually contains the column names, is displayed across all the printed pages.
In our example, we would like to have the column names (i.e., “Employee First Name” and “Employee Last Name”) displayed on all the printed pages.
Illustration – The data-set to be used
Here, we have a list of 60 employees. To start, copy the following list into an Excel spreadsheet:
| Employee First Name | Employee Last Name |
| Anthony | Collins |
| Gregory | Thomas |
| Walter | Scott |
| Doris | Gonzalez |
| Denise | Kelly |
| Joyce | Williams |
| Frank | Long |
| Wayne | Phillips |
| Brian | Thompson |
| Harold | Rogers |
| Jason | Young |
| Cynthia | Mitchell |
| Jack | Anderson |
| Donald | Stewart |
| Kimberly | Patterson |
| Teresa | Butler |
| Douglas | Johnson |
| Bobby | Green |
| David | Cooper |
| Todd | Simmons |
| Kevin | Washington |
| Kathy | Davis |
| Benjamin | Lewis |
| Brenda | Howard |
| Ronald | Cox |
| Kenneth | Wilson |
| Heather | Walker |
| Diana | King |
| Beverly | Wright |
| Linda | Garcia |
| Louis | Collins |
| Patricia | Morgan |
| Janet | Alexander |
| Jacqueline | Cook |
| Sean | Torres |
| Alan | Price |
| Ashley | Bryant |
| Annie | Sanders |
| Carolyn | Jenkins |
| Clarence | Peterson |
| Daniel | Hernandez |
| Ernest | Ward |
| John | Brown |
| Mildred | Edwards |
| Jose | Rodriguez |
| Andrea | Powell |
| Philip | Watson |
| Barbara | Foster |
| Jesse | Hughes |
| Marilyn | Russell |
| Evelyn | Bell |
| Debra | Roberts |
| Ann | Lopez |
| George | Parker |
| Carl | Diaz |
| Scott | Henderson |
| Earl | Turner |
| Jonathan | Taylor |
| Patrick | Nelson |
| Albert | Carter |
Your Excel spreadsheet should look as follows:
Steps to repeat specific rows on every printed page in Excel 2010
Now you are ready to execute the steps needed to repeat specific rows on every page when printing in Excel.
In our example, we would like to repeat the first row across all pages when printing in Excel. Here are the steps:
(1) Initially, go to the Page Layout tab
(2) Then, press the Print Titles icon
(3) The Page Setup menu will appear on your screen:
(4) Here, the first step you’ll need to take is to click inside the box of Rows to repeat at top
(5) Secondly, press anywhere on the first row of your excel spreadsheet, as this is the row that you wish to repeat on every page when printing in Excel:
(6) Now, this is how your Page Setup menu would look like (i.e., the “Rows to repeat at top” box will now contain the expression of $1:$1 which represents the first row that will be repeated across all pages when printing)
(7) Press OK and that’s it! Your first row will now be repeated across all pages every time you print the list of employees in Excel
Printing your list
(1) To confirm that your first row is indeed displayed on each page to be printed, you’ll need to go the Print section under the “File” tab (or simply press Ctrl+P on your spreadsheet).
You will now see a preview of the pages to be printed.
As you can see below, the first row (containing the “Employee First Name” and “Employee Last Name”) appears at the top of the first page to be printed.
(2) But what about your second page?
Similarly, if you switch to the second page to be printed, you’ll see the first row (i.e., “Employee First Name” and “Employee Last Name”) repeated at the top of the second page as well:
(3) Press Print and you’ll see the same results as above…