# Excel ROW function

## Summary

The Excel ROW function is used to return the row number of a cell reference. It’s a straightforward and versatile function that’s particularly useful in formulas where you need to identify the row position of a reference. This function can handle both single cell references and ranges, offering different outputs depending on the context.
##### Syntax
```				```
=ROW([reference])
```
```
• reference: [Optional] The cell or range of cells for which you want the row number. If omitted, ROW returns the row number of the cell where the formula is entered.
##### Return value
Returns the row number(s) of the specified cell or range.

## How to use

To use the ROW function, you can simply enter a cell reference as the argument. If you leave the argument blank, ROW returns the row number of the cell containing the formula. For ranges, it returns the row numbers for the entire range, which in Excel 365 and later versions will spill across multiple cells.

## Examples

##### Simple ROW
Row Number of a Single Cell:
```				```
=ROW(B3)

```
```
Returns 3, as B3 is in the third row.
##### ROW Without Reference
Automatic Reference to Current Cell:
```				```
=ROW()

```
```
Entered in cell E5, this formula returns 5, the row number of E5.
##### ROW with Range
Row Numbers for a Range:
```				```
=ROW(C2:C5)

```
```
Returns {2,3,4,5} in Excel 365, representing the row numbers for C2, C3, C4, and C5.
##### ROW in Excel Pre-365
First Row Number in a Range:
```				```
=ROW(C2:C5)
```
```
In pre-Excel 365, this formula would return 2, the row number of the first cell (C2) in the range.
##### ROW with Implicit Intersection
Single Value from a Range in Excel 365:
```				```
=@ROW(C2:C5)
```
```
Returns 2 in Excel 365 due to implicit intersection, representing the first row in the range.