Working with Excel’s coordinate system makes building data models extremely easy. You can retrieve the row index information of a cell using the ROW function and implement in other formulas.

Syntax

=ROW(cell or range reference you want get its row number)

Steps

  1. Begin by typing in =ROW(
  2. Select or type in the range reference that contains the full name (i.e. A7)
  3. Type in ) and press Enter to complete the formula

How

The ROW function returns the row index number of the target reference and it can be used with or without any parameters. If no arguments are included in the function, it will return the originating index for the formula. If a range is entered, the ROW function will give the row index of the cell in the top-left corner.

=ROW()

=ROW(A7)

=ROW(B7:D9)