Microsoft Excel 
ITTraining@sgul.ac.uk Page 5 St. George’s Information Services 
FILLING A SERIES 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
A series refers to a sequence of ordered entries 
in adjacent cells, such as the days of the week or 
months of the year. The fill technique can be 
used to create these in a worksheet for you,  
reducing the amount of time taken for data entry, 
and ensuring that the spelling is correct. Excel 
provides days and months as special built-in series 
that you can access. 
 
Try This Yourself: 
Open 
File Before starting this exercise 
you MUST open the file E707 
Filling_1.xlsx... 
 
Click on cell A4 
 
Move the mouse pointer to the 
small square (the fill handle) 
at the bottom right corner of 
the cell until the mouse pointer 
appears as a thin, black cross 
 
Drag the mouse pointer to 
column F 
Excel will fill the range with the 
first six months of the year… 
 
Click on cell A5 and repeat 
steps 2 and 3 to create the 
series of months with their full 
names 
You can also fill more than one 
row at a time… 
 
Select the range A6:A12 
 
Repeat steps 2 and 3 to fill 
across to column F 
 
Examine each of the series 
created by the filling process 
 
For Your Reference… 
To fill a series: 
1. Click on the first cell in the series 
2. Drag from the fill handle across as many 
columns as required 
Handy to Know… 
 As you drag the fill handle across, a tool tip 
appears below the fill pointer displaying the 
current value in the series. This is really 
handy when you want to end on a particular 
month, day or value. 
2 
3 
6