How to Autofill Numbers Without Dragging in Excel
In this article, you will learn how to autofill numbers without dragging the fill handle in Excel & Google Sheets.
If you don’t want to use drag and drop or double-click to autofill numbers in Excel, you can achieve the same effect using the fill command on the Ribbon.
Autofill Using Fill Command on the Ribbon
First, we need to (1) select the range of cells – including the initial value – where you want numbers to be populated (C2:C9). Then, (2) go to Home > Fill then (3) Series.
In the pop-up screen, leave the default values, as you need the column populated, and your Step value is 1.
This way, you get cells C2:C9 populated with numbers 1–8.
With this option, you could also put step value 2, which means that numbers should increase by 2. By doing that, you could autofill odd numbers. You could also enter a stop value if you want the numbers to be auto-filled up to a certain number.