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.
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.