The ROW function returns the row number of a specified cell reference. If the reference argument is omitted, the function returns the row number of the cell where the formula is entered.
=ROW(A5)→5Returns the row number of cell A5.
=ROW()→1Returns the row number of the cell containing the formula (assuming it is in row 1).
Select a cell
Click on the cell where you want to display the row number.
Enter the formula
Type =ROW() and press Enter to get the current row, or =ROW(reference) to get a specific row.
If you provide a range, ROW returns the row number of the first cell in that range.