How to Automatically Number Rows in Microsoft Excel

Guide

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.