ROW

  • Updated

Returns the row number of a cell.

Sample Usage

ROW(C5)
ROW()

Syntax

ROW([cell_reference])

  • cell_reference  - [OPTIONAL] The reference of the cell whose row number is to be returned. 

 

Examples

ROW(C5) returns the row number of cell C5
ROW() returns the row number of the cell in which the ROW function appears.

 

Notes

  • If the argument passed is a range of cells, the ROW function returns the row number of only the first row in the range.