Automatically number rows

To automatically number rows in Excel, you can use several methods depending on your needs. Here are the most common ways:

✅ Method 1: Fill Handle (Manual but Dynamic)

1. In cell A2 (or wherever you want numbering to start), type 1.
2. In cell A3, type 2.
3. Select both cells.
4. Drag the fill handle (small square at the bottom-right corner of the selection) down to automatically fill the sequence.

Excel will auto-fill the numbers in increasing order.

✅ Method 2: Formula-Based (Auto-updating)

If you want Excel to automatically renumber when rows are added or deleted, use this:

=ROW()-1

Place this in cell A2 assuming row 1 is a header. It subtracts 1 so the numbering starts from 1 at row 2. Adjust the number as needed if your data starts in a different row.

This updates dynamically when rows are added or removed.

✅ Method 3: Using COUNTA for Dynamic Ranges

If your data is in column B and starts from B2:

=COUNTA($B$2:B2)

This counts how many rows have data in column B and numbers them accordingly. Useful when you want row numbers only for rows that contain data.

✅ Bonus: Table Auto-Numbering

1. Select your data range.
2. Go to Insert > Table.
3. In the first column, use this formula:

   =ROW()-ROW(Table1[#Headers])
   

   (Replace Table1 with your actual table name.)

This keeps numbers aligned even when sorting or filtering.