How to Automatically Number Rows in Microsoft Excel
- George Apostolov
- 05 Sep 2025
Guide
Select the cell where you want the row numbering to begin.
In the first cell (e.g., A1), type the formula: =ROW().
Drag it down to automatically fill the row numbers in each subsequent cell.
Now that you've created numbered rows, you can adjust and customize them as needed.
Create your first interactive demo in minutes
No credit card required • Start building today
