FormulaCraft

ROW

ROW returns the row number of a given cell reference. When called without an argument it returns the row number of the cell containing the formula. It is frequently used to generate sequential numbers in a helper column or inside array formulas to create offsets.

Excel
=ROW(B3)
Google Sheets
=ROW(B3)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

ItemRow Check
Alpha
Beta
Gamma

=ROW(B3)→3

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1B3 is the cell reference whose row number you want.
  2. 2ROW(B3) returns 3 because B3 is in the third row of the spreadsheet.
  3. 3Omit the argument entirely to return the row number of the formula's own cell.

Need a version for your data?

Try: “Get the row number of a specific cell”

Related

VLOOKUPXLOOKUPINDEX / MATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: