ROW

Returns the row number or numbers of the specified cell reference.

Syntax

ROW( [Reference r] ) → IntegerOrArray

Parameters

r

Optional. The cell or range of cells for which to return the row number.

Remarks

This function returns the number of a cell row. For example, the function returns 1 for the first row, 2 for the second row, and so on.

If r is omitted, the function returns the row number of the current cell. If r identifies a range of cells with height greater than 1, ROW returns an array containing the numbers of all rows included in the range. For example, ROW(A1:C2) returns the array {1, 2, 3}.

Example

Formula

=ROW()
=ROW(A1:C2)

See Also

Function Reference
COLUMN Function
SHEET Function