Formula Guide

The Excel ROW Function
explained simply

ROW returns the row number of a reference — most often used to auto-number lists that stay correct even after sorting or deleting rows.

ExcelPro · 3 min read · Updated June 2026
Contents
  1. What does ROW do?
  2. Syntax
  3. 3 examples
  4. FAQ

What does ROW do?

ROW returns the row number of a given reference. With no argument, it returns the row number of the cell the formula itself is in.

The most common real use is auto-numbering a list (1, 2, 3...) in a way that automatically stays correct if rows are inserted, deleted, or the list is sorted.

Syntax

=ROW([reference])
ArgumentDescription
reference optionalA cell or range. If omitted, returns the row number of the cell containing the formula.

Examples

Example 1
Row number of the current cell
=ROW()

If this formula sits in row 7, it returns 7.

Example 2
Auto-numbering a list
=ROW()-1

Placed in row 2 of a list with headers in row 1, this returns 1, then 2, then 3 as you copy it down — numbering stays correct even if rows are later inserted.

Example 3
Row number of a specific cell
=ROW(C10)

Returns 10, regardless of which cell the formula itself is typed into.

Common mistakes

⚠️ Confusing ROW with ROWS

ROW returns a single row number. ROWS (plural) counts how many rows are in a range. They solve different problems.

FAQ

Does ROW change if I move the formula?
Yes — with no argument, it always reflects whichever row the formula currently sits in.
Can I use ROW to number a filtered list correctly?
Combine it with SUBTOTAL or aggregate functions for filtered lists — plain ROW does not skip hidden rows.

Practise Excel with real data

ExcelPro has 700+ hands-on Excel exercises across 7 career tracks — free to start, no download needed.

Start practicing free →

Related formulas

COLUMN INDIRECT