The Excel ROW Function

Home » Excel-Built-In-Functions » Excel-Lookup-And-Reference-Functions » Excel-Row-Function Search this site: Custom Search

Related Function:  COLUMN Function

Basic Description

The Excel Row function returns the first row number within a supplied reference, or if no reference is supplied, the function returns the number of the current row in the currently active Excel spreadsheet.

The syntax of the Row function is :

Where [reference] is an optional argument that specifies the Excel reference that you want to return the row number of. If [reference] 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 spreadsheets below show examples of the Excel Row function. The spreadsheet on the left shows the formulas and the spreadsheet on the right shows the results:

Note that the examples in cells A1-B2 of the above spreadsheet omit the [reference] argument. Therefore, the Excel Row function returns the row number of the cell that the function is entered into.

Example 2

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