Excel: Row Function

In Excel, the Row function returns the row number of a cell reference.

The syntax for the Row function is:

Row( reference )

reference is optional. It is a reference to a cell or range of cells.

Note:

If the reference parameter is omitted, then the Row function assumes that the reference is the cell address in which the Row function has been entered in.

For example, the Row function used in the picture above returns 1 because the Row function has been entered in cell A1. Therefore, it assumes the following formula:

=Row(A1)

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

=Row(B4) would return 4

=Row(A4:C4) would return 4