How to Automatically Number Rows in Microsoft Excel
- George Apostolov
How to Automatically Number Rows in Microsoft Excel: step-by-step 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.
Quick answer: 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.
About this Microsoft tutorial
Automatically number rows in Microsoft Excel by using the ROW formula and dragging to fill cells, then adjust your customized list. This guide shows how to automatically Number Rows in Microsoft Excel in 4 steps, starting with "Select the cell where you want the row numbering to begin" and finishing with "Now that you've created numbered rows, you can adjust and customize them as needed". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to automatically Number Rows in Microsoft Excel?
4 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to Back Up Microsoft Planner, How to Bold Lines in Microsoft Excel and How to Bring In Microsoft Planner Data to Power BI. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
