How to Autofill Numbers Without Dragging in Excel

This tutorial demonstrates how to autofill numbers without dragging the fill handle in Excel and 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

1. Select the range of cells – including the initial value – where you want numbers to be populated (C2:C9).
2. Then, go to Home > Fill.
3. Click Series.

 

 

4. 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 use 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 filled up to a certain number.