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.