See all How-To Articles

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.

autofill numbers fill excel 2

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.

autofill numbers fill

In the pop-up screen, leave the default values, as you need the column populated, and your Step value is 1.

autofill numbers fill excel

This way, you get cells C2:C9 populated with numbers 1–8.

autofill numbers fill excel 2

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.