Get ROW Number Formula – Excel & Google Sheets

This Tutorial demonstrates how to use the Excel ROW Function in Excel to look up the row number.

ROW Main Function

ROW Function Overview

The ROW Function Returns the row number of a cell reference.

To use the ROW Excel Worksheet Function, select a cell and type:
row formula syntax
(Notice how the formula inputs appear)

ROW function Syntax and inputs:

reference – Cell reference that you want to determine the row # of.

 

AutoMacro - VBA Code Generator

ROW Function – Single Cell

The ROW Function returns the row number of a specific cell reference. 

ROW EX 01

ROW Function with no Reference

If no cell reference is provided, the ROW Function will return the row number where the formula is entered

ROW EX 02

ROW Function with a Range

You can also enter entire ranges of cells into the ROW Function. When doing so, the ROW Function behaves differently in Excel 2019 (or earlier) vs. Excel 365 or newer version of Excel.

Excel 2019 or older

In previous versions of Excel, the ROW Function returns an array containing the row values of all the cells in the range, but only displays the first result in the cell.

ROW EX 03

 

If you click the cell containing the formula and press F9, all the results are displayed in curly brackets as an array.

ROW EX 04

 

Excel 365

However, Excel 365 (and newer versions of Excel, presumably) comes with a spill range feature. Here, the ROW Function will return the rows of all cells in the range, “spilled” into the next cells.

ROW EX 05

ROW Function in Google Sheets

The ROW Function works exactly the same in Google Sheets as in Excel:

ROW Google Function

Additional Notes

Use the ROW Function to return the row number of a cell reference.

Return to the List of all Functions in Excel

 

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!