Quick Navigation
ROW Function
Summary
The ROW function in Excel returns the row number of a specified cell reference or the current cell if no reference is provided. This is essential for dynamic formulas, array operations, and creating position-aware calculations.
Syntax
ROW([reference])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| reference | Reference |
No | The cell, range, or omitted for current cell row number |
Using the ROW Function
ROW is perfect for building dynamic ranges, creating index-based lookups, generating sequential numbers, and position-dependent calculations. Use it standalone for current position or with ranges for array operations.
Common ROW Examples
Basic Current Row
=ROW()Returns the row number of the cell containing the formula (e.g., 5 if in row 5).
Specific Cell Row
=ROW(C10)Returns 10, the row number of cell C10.
Dynamic Range Start
=ROW(A1:A10)Entered as array formula, returns {1;2;3;4;5;6;7;8;9;10} for each row.
Offset Calculation
=INDIRECT("A"&ROW())References same column, current row - creates vertical lookup.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Reference points to multiple areas (non-contiguous ranges)
Solution: Use single contiguous range or individual cell references
Unexpected single value
Cause: Expecting array but entered as regular formula
Solution: Use Ctrl+Shift+Enter (legacy Excel) or ensure dynamic array compatibility
Notes
- Cannot reference multiple non-contiguous areas
- In dynamic array Excel, spills row numbers vertically
- Perfect companion to COLUMN function for 2D positioning
- Use with INDIRECT for powerful dynamic references
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365
Not available in:
Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+