# How to AutoFill Ascending Numbers in Excel – 5 Quick Methods

### Method 1 –Â  AutoFill Ascending Numbers Using the Fill Handle in Excel

The â€˜Fill Handleâ€™ Â will be used in the sample dataset.

STEPS:

• Select a cell and enter the first number manually. Here,Â B5 and 100.

• Drag down the Fill Handle or double-click it. The â€˜AutoFill Optionsâ€™ will be displayed.
• Select Fill Series.

• The rest of the cells will be filled in ascending order.

• To maintain a step value, enter the first two values and select them. Here, 100 and 105 in B5 andÂ B6.

• Use the Fill Handle to see the result.

Read More: How to AutoFill Numbers in Excel

### Method 2 – Using the Fill Command to AutoFill Ascending Numbers

The autofill formula will be used here.

STEPS:

• Select a cell and enter the first number.

• Go to the Home tab and selectÂ Fill.
• Choose Series.

• Click OK.

• You will see an ascending series of numbers.

• To change the step value, use the â€˜Seriesâ€™Â window.

Here, the step value is 5. You can also select the stop value. If you need a geometric ascending pattern select â€˜Growthâ€™ in the Type field.

• Click OK to see the result.

### Method 3 – FillingÂ  Ascending Numbers by Skipping a Row in Excel

The repeat number pattern to autofill ascending numbers will be used.

STEPS:

• Enter the first number manually in the first cell. Here, 100 inÂ B5.
• Select B5 and B6.

• Drag down the Fill Handle.

• You will see the result.

### Method 4 – AutoFilling Ascending Numbers with Formulas

#### 4.1 Using the ROW Function

The ROW Function returns the values of a row number for a cell or range.

STEPS:

• Select B5.
• Enter the formula:
`=ROW()`

• Press Enter to see the result.

Here, the ROW Function displays the row number of the cell containing the formula.

• Use the Fill Handle to see the result.

• To start numbering from 1, enter:
`=ROW(B1)`

The ROW Function displays the row number ofÂ B1.

• Press Enter to see the result.

• Use the Fill Handle to see the final output.

#### 4.2 Using the OFFSET Function

The OFFSET Function Â returns a range that is a specified number of rows and columns from a reference cell.

STEPS:

• Select B6.
• Enter the formula:
`=OFFSET(B6,-1,O)+1`

The OFFSET Function takes the value of the previous cell and adds 1 to it. The value ofÂ B5 is 0 because it is empty.

• Press Enter to see the result.

• Use the Fill Handle to see the ascending numbers.

• To start numbering from 5, add 5 instead of 1 in the previous formula.
`=OFFSET(B6,-1,0)+5`

• Press Enter and drag down the Fill Handle to see the result.

NOTE: To use this formula, the cell before the one that contains the formula must be empty. Here, B5.

Read More: How to Auto Number Cells in ExcelÂ

#### 4.3 Using the COUNTA Function

The COUNTA Function counts the number of non-blank cells in a cell range or the cell reference and can be usedÂ to autofill columns in ascending order.

STEPS:

• Select B5 and enter the formula:
`=COUNTA(\$C\$5:C5)`

C5 was locked,Â using the dollar (\$) sign. The COUNTA Function is applied to the given range.

• Press Enter and use the Fill Handle to see the result.

• To start numbering from 10,Â add 9 to the formula.
`=COUNTA(\$C\$5:C5)+9`

• Press Enter and use the Fill Handle to see the result.

#### 4.4 Using the SUBTOTAL Function

The SUBTOTAL Function can be used to create a formula and autofill ascending numbers in a column/row.

STEPS:

• SelectÂ B5 and enter the formula below.
`=SUBTOTAL(3,\$C\$5:C5)`

3Â specifies the use of COUNTA and the second argument describes the range in which the SUBTOTAL Function is applied.

• Press Enter and then use the Fill Handle.

• If you use Filter and hide some rows, the ascending numbers will automatically be updated.

#### 4.5 Adding 1 to the Previous Row

STEPS:

• Enter a value manually in the first cell. Here, 1 in B5.

• Now, enter the formula:
`=B5+1`

• Press Enter and use the Fill Handle to see the result.

### Method 5 – Applying an Excel Table to AutoFill Ascending Numbers

STEPS:

• Select any cell in your dataset.
• Go to the Insert tab and select Table.

• In Create Table, select â€˜My table has headersâ€™.
• Click OK.

• Enter this formula in B5.
`=ROW()-ROW(Table2[#Headers])`

• Press Enter to see the result.

• If you insert a new row, the ascending numbers will automatically be updated.

## Related Articles

<< Go Back to Autofill Numbers |

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF