How to find row numbers and more

Excel’sROWfunctionreturns the row number of a reference.

The COLUMN function returns the column number.

The examples in this tutorial show you how to use these ROW andCOLUMN functions.

Row function dialog in Excel

Columns are numbered left to right with column A being the first column.

The number 2 appears in cell B2 since the function is located in the second row of the worksheet.

When you select cell B2, the complete function =ROW() appears in theformula barabove the worksheet.

ROW and COLUMN functions described in Excel

ROW function in Excel

=COLUMN(F4) in B5 in Excel

Excel Insert Function