Introduction
Excel ROW Function function can be used when you want to get the row number of a cell reference. For example, =ROW(B4) would return 4, as it is in the fourth row.
When to use Excel ROW Function
- Excel ROW Function function can be used when you want to get the row number of a cell reference.
- it is usually use in the combination of a formular function also rather than isolated use
Syntax
=ROW([reference])
Input Arguments
- [reference] – An optional argument that refers to a cell or range of cells. If this argument is omitted, ROW function returns the row number of the cell in which the formula resides.
Additional Notes
- If the reference is a range of cells, ROW function returns the row number of the top-most row in the specified range. For example, =ROW(B5:D10) would return 5 as the top-most row is B2 for which the row number is 5.
- If the reference is entered as an array, ROW function returns the row numbers of all the rows in that array.
- Reference can not refer to multiple references or addresses.
- ROW function can be particularly helpful when you want to get a sequence of numbers in a column. For example, enter =ROW() in cell A1 and drag it down. You will have sequence of numbers 1.2.3..