How to Automatically Fill Sequential Data Using Fill Series in Microsoft Excel

When it comes to Microsoft Excel, there are a lot of data involved, numbers, days, more numbers, the list is endless. It is next to impossible to get all your Excel tasks done without any sort of automation. One of the most important automation tricks anyone might need is the automatic generation of number series. Well, there is the classic way of entering the first 3 numbers in 3 cells of a single column and then dragging the values to autofill the rest of the series in the cells that we select. Well, who likes to stick to the classic way always?


ADVERTISEMENT

In this article, we introduce the Fill Series functionality in excel, using which you can do wonders with series generation!

How to Use Fill Series Functionality on Columns

Step 1: Click on a cell and enter the starting number of your series.

In the example below, I have clicked on cell D1 and entered the number 20.

 

1 Enter Number Optimized

 

Step 2: As next, you need to select the cells where you want the rest of your series to be generated at. This can be an entire column or a selected continuous range of cells in a column as well.

Now, make sure you are on the HOME tab.


ADVERTISEMENT

At the right end of the HOME ribbon, you will be able to find a button named Fill. Click on it first and then click on the option named Series.

 

2 Fill Series Optimized

 

Step 3: In the Series window that opens next, enter in the ending range value of your series in the text field named Stop Value. For example, if your series is from 20 to 40, the number you need to enter in the Stop value field is 40.

Hit the OK button.

 

3 Stop Value Optimized

 

Step 4: That’s it. You can now see that your series is automatically generated in the column range that you selected.

 

4 Result Optimized

 

How to Use Fill Series Functionality on Rows

The steps to generate a series in rows are also similar to that of columns. Please follow the steps below to achieve this easily.

Step 1: Click on the cell where you want your series to start from and enter the starting number of your series inside the cell.

Now select the range of continuous cells, in a single row, where you want your series to be generated.

As next, at the right end of the HOME ribbon, click on Fill dropdown and then click on the Series option.

 

 

5 Row Series Optimized

 

Step 2: Now in the Series window, just like how it was done for the columns, enter in the Stop value for Rows. Hit the OK button once done.

The Stop value is the value at which your series would stop. For example, if you have selected 30 cells and you have given the start value as 10 and stop value as 20, then only 10 cells would get populated and the series would be 10,11,12,13..19,20.


ADVERTISEMENT

 

6 Row Stop Value Optimized

 

Step 3: There you go! You now see the series automatically generated in the row range that you have selected.

 

7 Row Result Optimized

 

Hope you had fun exploring the Fill Series functionality in Microsoft Excel. Thank you for reading.

ADVERTISEMENT