# 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.

Formulas:
AB
1=ROW( )=ROW( )
2=ROW( )=ROW( )
3=ROW( E7 )=ROW( G8:H9 )
Results:
AB
111
222
378

Note that in the above examples:

• The examples in cells A1-B2 omit the [reference] argument. Therefore, in these cases, the Excel Row function returns the row number of the cell that the function is entered into.
• The example in cell A3 provides the reference for cell E7 to the Row function. Therefore, in this case, the function returns row number 7.
• The example in cell B3 provides the range G8:H9 to the Row function. Therefore, in this case, the function returns the row number of the first cell in the supplied range (i.e. cell G8), which is row number 8.

## 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.