ROW

Syntax #1:

ROW

Returns the number of the row containing the cell in which the function is evaluated.

Example:

ROW in cell D16

returns the number 16.


Syntax #2:

ROW(cell_reference|range)

If a cell reference is specified, ROW returns the number of the row of that cell.

If a range is specified, the number of the first row in the range is returned.

Example:

ROW(A3:C12)

returns the number 3.