Filling Series in Excel

In this lesson you can learn how to fill data series.


Entering huge series of data, it is not comfortable using drag. Much easier is to use Excel’s functionality.Click the cell. Write the first value which you want to start. For example 1.Fill Series Step value

Go to Ribbon. In the Home tab find Editing section. Click Fill and choose Series.

Fill Series Ribbon Excel

Now you can choose the Type of series. In the example below I chose Linear Type.

Fill Linear Series

Values filled 1 to 10000 in column A.

Series filled


You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell