The Excel ROW Function

Related Function:
COLUMN Function

Function Description

The Excel Row function returns the first row number within a supplied reference or the number of the current row.

The syntax of the Row function is:

ROW( [reference] )

Where [reference] is an optional argument that specifies the Excel reference that you want to return the row number of. If the [reference] argument is omitted, the function returns the row number of the current cell (i.e. the cell that the function is entered into).

Row Function Examples

The spreadsheet below shows six examples of the Excel Row function.

  A B
1 =ROW( ) =ROW( )
2 =ROW( ) =ROW( )
3 =ROW( E7 ) =ROW( G8:H9 )
  A B
1 1 1
2 2 2
3 7 8

Note that in the above examples:

Further Examples

For a practical example of the Excel Row function, see the Variable Drop-Down List page of this website.

Also, for further examples of the Excel Row function, see the Microsoft Office website.