Complete Range of cells

[JuanHurtado72]

Excel is not letting me use the autofill function when I am creating a numeric list of continuous numbers. If I drag the bottom right corner down, the automatic function just copies the first number in all the subsequent cells. I need the continuous numbers to appear. ie. 123456....

[#2]

@JuanHurtado72 If you want to create a range

1

2

3

...

then you should enter the first two numbers, select the two cells, then use the fill handle:

If you have Microsoft 365 or Office 2021, you can use the SEQUENCE function.

The formula =SEQUENCE(10) will generate the numbers 1 to 10.

Yet another method: enter the starting number in a cell. With that cell selected, click Fill > Series on the Home tab of the ribbon.