How do I use ROW in Excel?
Use ROW when you want to return a row number. Enter Reference in that order, then add optional arguments when needed.
Excel Function
ROW
Returns row number of a reference.
ROW([reference])Arguments
reference
OptionalSpecify a single cell reference.
Practice Preview
Use ROW to return the result with these settings (Reference: B2 (cell B2 (Product Name in column B))).
Example Table
| # | AProduct ID | BProduct Name | CPrice | DStock |
|---|---|---|---|---|
| 2 | P001 | Apple | 120 | 80 |
| 3 | P002 | Banana | 98 | 120 |
| 4 | P003 | Notebook | 450 | 35 |
| 5 | P004 | Pen | 300 | 60 |
| 6 | P005 | Grapes | 150 | 45 |
| 7 | P006 | Ruler | 250 | 20 |
| 8 | P007 | Peach | 86 | 55 |
How to Use (Formula)
=ROW(B2)Result
2
Practice This Function
ROW FAQ
Where can I practice ROW?
Use the "Start Function Practice" button to jump straight into ROW drills.
What arguments does ROW use?
The main arguments are Reference. Start with the required ones, then add optional arguments if needed.