Complete Range of cells

Copper Contributor

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....

1 Reply

@JuanHurtado72 If you want to create a range





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.