ROW Function Explained

The ROW Function in Microsoft Excel returns the row number of a cell reference. It takes a single argument, which is a cell reference, and returns the row number of that cell. For example, ROW(A1) returns 1, as A1 is the first row in the worksheet.

ROW Function Syntax

ROW(reference)

  • reference: The cell or range of cells for which you want to know the row number.