ROW Function

About

ROW function in Excel returns the row number of a reference. When no reference is specified, ROW function returns row number of the cell containing the formula.

Function Type

Lookup and reference

Purpose

Get the row number of a reference

Return value

A number representing the row.

Syntax

=ROW([reference])

Arguments

reference – [optional] a cell reference or a range reference.


Example


Notes

ROW function doesn’t accept multiple references.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel