How to use ROW Function in Excel

Row function in excel is a worksheet function in excel which is used to show the current index number of the row of the selected or target cell, this is an inbuilt function and takes only one argument as the reference, the method to use this function is as follows,=ROW( Value ), it will only tell the row number of the cell not its value.

Syntax:= ROW ([reference])

The ROW function syntax has the following arguments:

Reference    Optional. The cell or range of cells for which you want the row number.

  • If reference is omitted, it is assumed to be the reference of the cell in which the ROW function appears.
  • If reference is a range of cells, and if ROW is entered as a vertical array, ROW returns the row numbers of reference as a vertical array.
  • Reference cannot refer to multiple areas.

Example: Let’s look at some Excel ROW function examples and explore how to use the ROW function as a worksheet function in Microsoft Excel:

Example 1:

Syntax:  =ROW()


Based on the Excel spreadsheet above, the following ROW examples would return:

Syntax: =ROW(A7)
Result: 7

Syntax: =ROW(C6)
Result: 6

Syntax: =ROW(B3)
Result: 3

Syntax: =ROW(D9)
Result: 9

Syntax: =ROW(A3:B5)
Result: 3

Syntax: =ROW(B5:D8)
Result: 5

Example 2:

It is most widely used in Conditional formatting to highlight the rows in the data.


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

Add a Comment

Your email address will not be published. Required fields are marked *