ROW

Get the row number of a reference

Example

Related Functions

ROW

Summary 

The Excel ROW function returns the row number for a reference.

Purpose 

Get the row number of a reference

Return value 

A number representing the row.

Syntax 

=ROW ([reference])

Arguments 

  • reference - [optional] A reference to a cell or range of cells.

Usage notes 

Use the ROW function to get the row number for a cell reference or a range.

  • Reference is optional and will default to the cell in which the COLUMN function exists.
  • Reference cannot include multiple references or addresses.

0 votes. 0 / 5