Skip to content

row

Row number of a reference.

v = row(reference)

Returns the row number of reference. Without arguments, returns the row of the cell containing the formula.

row() % current row
row(B5) % 5
  • column — Column number of a reference.
  • rows — Number of rows in a reference.
  • address — Cell address as a text string.