filling a series in excel


Excel is designed to save you time

Each time you sense a routine, Excel normally has a way to automate it.

Filling series are a great time saver and so simple to master.  Consider the example of creating a monthly roster or calendar where we commonly use days of the week, dates or even months.

We are going to use the fill series function to save us from a lot of typing.

filling series excel

In Cell A1 type the Word Sunday and press enter to lock it in.

Now navigate your mouse to the bottom right hand corner of the cell, you should notice your pointer change into a black cross as per the image

Click and drag (across or down)

You should have the days of the weeks filled in the cells which you dragged down until.


Getting your pointer to change to the black cross (or as Microsoft calls it, the fill handle) can take a bit of finesse, if you’re finding it hard just increase the zoom (bottom right corner).

You can use the fill handle to complete many series common ones include:

common series in excel

Share on twitter
Share on linkedin

More Insights

unsure of the best course?

Reach out to us today and get a complimentary consultation.