**There are 3 ways to fill a series of numbers, or dates, with Excel**

**The fill-handle**By writing the first two values, the fill-handle will generate the fill-handle

**The fill menu**From the ribbon, you can fill the series with this tool

**The SEQUENCE function**For those who work with Excel 365, this function will generate a series of numbers.

## Fill series of numbers

If you want to create a series of numbers quickly, the trick is simple

- Write the first value
- Write the second value
- Select the 2 cells
- Use the fill handle to extend the selection

Excel will extend the selection **according to the step between the 2 numbers**. Look at this video to see how it works with positives, negatives, and decimal numbers.

## Fill series for thousands of data

But **if you have to create an extensive list of numbers**, using the fill handle is useless because it takes too much time 😤 It's better to use the tool **Home > Fill** **> Series**

In the dialog box, you fill in these parameters

- Select the cell containing the starting value
- Select the orientation (here columns because you want the result in the same column)
- Indicate the step (by default, it's 1)
- Indicate the last value to reach

And the result is **a list of values starting from 1 to 5000 with a step of 2** 😀👍

## Fill a series with SEQUENCE

If you work with Excel 365, Excel Online, or Excel 2021, you can use the SEQUENCE function to create your series of number

=SEQUENCE(number of rows, number of columns, starting value, step)

For instance, to create a series from 0 to 50 with a step of 5, you write the following formula

=SEQUENCE(11, ,0,5)

Then, to convert the result of your formula to value, you must perform a copy-paste value

## Create a series of dates

If you want to create a series of dates, the 3 same techniques (fill handle, tool Fill series and SEQUENCE) can be used. But also Excel respects the number of days in a month. For example, you can easily create a series of weeks with a step of 7 days

The same technique can be used for the months.

- You write the 2 first months
- You select the 2 cells
- Expand the selection

## Other Excel tricks

Here is a list of articles that could be also useful:

Julie Williams

11/10/2022 @ 14:18

Thank you so much for providing such an intresting information.