Forum Discussion
Complete Range of cells
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....
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.
