Exceljet

Quick, clean, and to the point

Excel ROW Function

Excel ROW function
Summary 

The Excel ROW function returns the row number for a reference. For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula.

Purpose 
Get the row number of a reference
Return value 
A number representing the row.
Syntax 
=ROW ([reference])
Arguments 
  • reference - [optional] A reference to a cell or range of cells.
Usage notes 

Use the ROW function to get the row number for a cell reference or a range. For example:

=ROW(A3) // returns 3
=ROW(D5) // returns 5
=ROW(F10:J15) // returns 10

Note the ROW function returns a number for the row in a worksheet. If you need to find a row number based on a lookup or match, see the MATCH function

Notes:

  • Reference is optional and will default to the cell in which the ROW function exists.
  • Reference cannot include multiple references or addresses.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.