Repeat Specific Rows on Every Printed Page in Excel 2010

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 NameEmployee Last Name
AnthonyCollins
GregoryThomas
WalterScott
DorisGonzalez
DeniseKelly
JoyceWilliams
FrankLong
WaynePhillips
BrianThompson
HaroldRogers
JasonYoung
CynthiaMitchell
JackAnderson
DonaldStewart
KimberlyPatterson
TeresaButler
DouglasJohnson
BobbyGreen
DavidCooper
ToddSimmons
KevinWashington
KathyDavis
BenjaminLewis
BrendaHoward
RonaldCox
KennethWilson
HeatherWalker
DianaKing
BeverlyWright
LindaGarcia
LouisCollins
PatriciaMorgan
JanetAlexander
JacquelineCook
SeanTorres
AlanPrice
AshleyBryant
AnnieSanders
CarolynJenkins
ClarencePeterson
DanielHernandez
ErnestWard
JohnBrown
MildredEdwards
JoseRodriguez
AndreaPowell
PhilipWatson
BarbaraFoster
JesseHughes
MarilynRussell
EvelynBell
DebraRoberts
AnnLopez
GeorgeParker
CarlDiaz
ScottHenderson
EarlTurner
JonathanTaylor
PatrickNelson
AlbertCarter

 

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

 

Print Titles in Excel 2010

 

(3) The Page Setup menu will appear on your screen:

 

Repeat Specific Rows on Every Printed Page in Excel 2010

 

(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:

 

Repeat specific rows on every page when printing in Excel 2010

 

(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…