![](https://xlncad.com/wp-content/uploads/2020/07/ROW_1-1.png)
Table of Contents
About
ROW function in Excel returns the row number of a reference. When no reference is specified, ROW function returns row number of the cell containing the formula.
Function Type
Lookup and reference
Purpose
Get the row number of a reference
Return value
A number representing the row.
Syntax
=ROW([reference])
Arguments
reference – [optional] a cell reference or a range reference.
Example
![](https://xlncad.com/wp-content/uploads/2020/07/ROW_1.png)
Notes
ROW function doesn’t accept multiple references.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)