How to use Excel ROW Function

how to use excel row function

Quick Intro

Use Excel ROW Function to get row number of a reference.  For example, if you refer to cell D5 it will return 5 in the result as D5 is in the 5th row.

Syntax

ROW([reference])

  • reference A cell reference or a range of cells for which you want to check the row number.

More Information on Excel ROW Function

  • If you skip specifying range, it will return the row number of the current cell.
  • If refer more than one cell, it will return row number of the upper left cell of range.

Examples

In the below example, we have used row function check the row number of the same cell where I have used the function.

Excel For Excel ROW Function Same Cell

In the below example, we have referred to the another cell to get the row number of that cell.

Excel For Excel ROW Function Another Cell

You can use row function to create a serial number list in your worksheet. All you have to do just enter row functions in a cell and drag it up to the cell you want to add serial numbers.

Use Excel ROW Function To Insert Serial Numbers

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel ROW Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have COLUMN function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.