Last Updated on October 25, 2021 by Jake Sheridan
In this tutorial, you will learn how to fill series in Google Sheets.
Manual data entry is time consuming and prone to error, so it’s good to eliminate it wherever possible. A frequent recurring data entry task for spreadsheet users is creating a series of sequential numbers or dates going down a column. While you can manually type each entry in the column, Google Sheets provides a faster solution. You can automatically create a series or list in just a few seconds using the Google Sheets Fill Down tool. Read on to learn how.
Filling a Consecutive Number Series
The simplest number series is a series of consecutive numbers. Here’s how to generate a consecutive number series in Google Sheets:
Enter the number 1 in the cell you want to start the series in, and the number 2 directly below it
Select the cells containing the 1 and 2 from Step 1. A square, blue drag handle will appear at the lower right corner of the selection
Click on the drag handle and and drag it down over all the cells you want to fill with the consecutive number sequence
A consecutive number sequence will be generated in the cells
Note that you can start the sequence with any number, you do not have to start with 1
Filling a Sequential Number Series
Google Sheets can fill non-consecutive series of numbers, provided the interval between the numbers is always the same.
As with consecutive numbers, we first need to first give Google Sheets two (or more) starting numbers to generate the series from. Type the first two numbers of the series into the first two cells of the column you want to fill with the series. For example, if you want to generate a series of every 11th number starting with 111, type 111 into the first cell and 122 into the second cell
Select the two numbers you’ve entered, then click on the drag handle and drag the series down as far as you need
Filling a Date or Month Series
Perhaps even more useful than filling number series is Google Sheets’ ability to fill lists of dates. Like Number series, the dates can be separated by any interval. For example, you can generate a list of every date, every Friday, or a list of consecutive months
Filling a consecutive date series is much the same as the number series listed above. Simply add the first two entries in the series, then drag down and let Google Sheets fill in the rest
If you want to fill a month series, start by typing the first two month names into the first two cells. Include the year if you want it displayed in the series
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to fill series in Google Sheets. Want more? Check out all the Google Sheets Tutorials.