ROW Function

Spread the love

Returns the row number of a reference.



The ROW function syntax has the following arguments:

  • Reference Optional. The cell or range of cells for which you want the row number.
    • If reference is omitted, it is assumed to be the reference of the cell in which the ROW function appears.
    • If reference is a range of cells, and if ROW is entered as a vertical array, ROW returns the row numbers of reference as a vertical array.
    • Reference cannot refer to multiple areas.
=ROW()Row in which the formula appears2
=ROW(C10)Row of the reference10