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.
- 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.
In the below example, we have used row function check the row number of the same cell where I have used the function.
In the below example, we have referred to the another cell to get the row number of that 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.
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.