# How to Automatically Number Rows in Microsoft Excel

> To automatically number rows in Microsoft Excel, select your starting cell, enter the formula =ROW(), and drag the fill handle down. Finally, adjust and customize your numbered rows as needed.

Canonical: https://livedemo.ai/tutorials/how-to-automatically-number-rows-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2fb9d673bd5aa8e62456/preview?step=1

## Steps

1. Select the cell where you want the row numbering to begin.
2. In the first cell (e.g., A1), type the formula: =ROW() .
3. Drag it down to automatically fill the row numbers in each subsequent cell.
4. Now that you've created numbered rows, you can adjust and customize them as needed.