April 21, 2021

ROW function in Excel

In this lesson we will learn how the ROW function works in Excel. The ROW Function is used to get the row number of a cell reference. Like ROW(F4) will return 4 as the referred cell F4 is in the 4th row of the excel spreadsheet.

=ROW([reference])
  • reference – [optional] A reference to a cell or range of cells. If this argument is omitted, the ROW function then returns the row number of the cell in which the formula resides.

Let’s understand with a simple example as follows. Here we have added the below ROW function in cell E1.

=ROW(B2:D5)

It returned the row number as 2 which is the top most row in the specified range of cells(B2:D5).

In below example we used ROW function in cell E3 without any argument. So it returned the row number of the current cell which is 3.

You can also check here to understand how the ROW function works in Google Sheet.

You can also check here to understand how the ROWS function works in Google Sheet.

You can also check here to understand how the ROWS function works in Excel.

You can also check here to understand how the COLUMNS function works in Excel.

You can also check here to understand how the COLUMNS function works in Google Sheet.

You can also check here to understand how the COLUMN function works in Excel.

You can also check here to understand how the COLUMN function works in Google Sheet.

Leave a Reply

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