> ## Content Index
> Fetch the complete content index at: https://chale.tech/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to auto-number rows in Excel (1, 2, 3… without typing)
- URL: https://chale.tech/auto-number-rows-excel/
- Published: 2026-11-17T13:00:00.000Z
- Updated: 2026-11-17T13:00:00.000Z
- Description: Number rows in Excel automatically with the fill handle, the ROW function or SEQUENCE, keep numbers correct after deleting rows, and number only rows that have data.
- Author: Isaac Nana Yaw Annor
- Tags: How-To, Computers

Numbering a class list, staff list or stock sheet by hand is slow and breaks when you add or delete rows. Excel can do it for you.

## Method 1: fill handle (quickest)

1. Type **1** in A2 and **2** in A3.
2. Select both cells.
3. Double-click the **fill handle** (small square at the bottom-right of the selection). Excel fills down as far as the data next to it goes.

## Method 2: ROW function (stays correct)

In A2 type `=ROW()-1` and fill down. If your header is on row 1, this gives 1 on row 2, 2 on row 3, and so on. Deleting a row renumbers everything.

## Method 3: SEQUENCE (Excel 365/2021)

Type `=SEQUENCE(100)` in A2 to get 1 to 100 instantly. Use `=SEQUENCE(COUNTA(B2:B500))` to match the number of names in column B.

## Number only rows with data

In A2: `=IF(B2="","",COUNTA($B$2:B2))`, then fill down. Empty rows stay blank.

| Method       | Best for            | Updates automatically? |
| ------------ | ------------------- | ---------------------- |
| Fill handle  | Quick one-off lists | No                     |
| \=ROW()-1    | Lists you edit      | Yes                    |
| \=SEQUENCE() | Excel 365/2021      | Yes                    |
| IF + COUNTA  | Lists with gaps     | Yes                    |

## Google Sheets

The same formulas work: =ROW()-1, =SEQUENCE(100) and the IF/COUNTA formula.

## Related guides

- [How to use AI to write Excel formulas](https://chale.tech/ai-excel-formulas/)
- [Create a Google Form](https://chale.tech/create-google-form/)

*Checked on 10 November 2026 for Windows 11 and current Microsoft 365\. Older versions may look slightly different.*

## Common questions

### How do I quickly number rows in Excel?

Type 1 and 2 in the first two cells, select both, then double-click the fill handle (small square at the bottom-right).

### How do I keep numbering correct after deleting rows?

Use =ROW()-1 (adjust for header rows) instead of typed numbers.

### How do I number 1 to 100 in one go?

In Excel 365/2021, type =SEQUENCE(100) in the first cell.

### How do I number only rows with names?

Use =IF(B2="","",COUNTA($B$2:B2)) and fill down.

## Sources

- [Microsoft Excel help and learning](https://support.microsoft.com/en-us/excel?ref=chale.tech)
- [Microsoft Support: SEQUENCE function](https://support.microsoft.com/en-us/office/sequence-function-57467a98-57e0-4817-9f14-2eb78519ca90?ref=chale.tech)