Related Function:

The ROW function returns the first row number within a supplied reference, or if no reference is supplied, the function returns the number of the current row in the currently active Excel spreadsheet.

Syntax

=ROW([reference])

Arguments

Argument Description
[reference] An optional argument that specifies the Excel reference that you want to return the row number of

Note: If [reference] is omitted, the function returns the row number of the current cell, i.e. the cell that the function is entered into.

Examples

  A B C
1 Formula Formula Notes
2 =ROW() 2 [reference] is omitted, therefore, the ROW function returns the row number of the cell that the function is entered into
3 =ROW() 3
4 =ROW(E6) 6