How to use Excel ROW function


ROW function in excel is a reference function. It returns the row number of a cell to which reference is made. If we provide no reference than function returns the reference value of the cell in which the function is written. For example =ROW(A9) returns 9 as A9 is the 9th row in Excel.




Reference- It is the reference made to a cell or a range of cells whose row number has to be found. It is optional, and since function will use default reference of the cell in which it is used.


  • It returns a number for the row in Excel based on reference, if a row number is to be found using lookup, use the MATCH function.
  • Reference here is not compulsory since function will use default reference of the cell in which it is used.
  • In this function, only single reference can be used and multiples are not allowed.
  • If reference to more than one cell is made, it will return the cell number of uppermost left reference.
  • It can also be used to create a list of row numbers.(See in Examples)
  • It can also be used to dynamically increment a calculation value.(See in Examples)


  1. In this example Row function gives us value ‘1’ since we have used the formula =ROW(A1)
row function

In this example a serial vise list of row numbers is created using ROW function simultaneously.  

In this example a dynamical increment of a calculation is done using the ROW function. It means value of the calculation will automatically increase when function is pasted to a new cell. Here the formula  =A12*(ROW(D12)-11) is used in column D12 , this multiplies value in column A12 by 1 and increment by one as we move to the next column.

2 thoughts on “How to use Excel ROW function”


    Dear Sir

    please send activation code for use your gst software

    1. Excelhub

      pls subscribe to get code

Leave a Comment

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