ROW Function in Excel: Row Number of a Cell

⏱ 1 min readUpdated 28 September 2026

LookupLevel: BeginnerAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Example 2
  5. Related functions

ROW returns the row number of a reference (or of the cell it is in). It is the quiet engine behind serial numbers and many array tricks.

Syntax

=ROW([reference])
Argument What it means
reference Optional cell; omitted = the formula’s own row.

Examples

Example 1

=ROW()-1

Serial numbers that stay correct when rows are sorted or deleted (header in row 1).

Example 2

=MOD(ROW(),2)=0

Conditional-formatting rule for banded rows.

ROWS · COLUMN · SEQUENCE

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZHARMEAN Function in Excel: The Right Average for RatesExcel Functions A–ZAMORLINC Function in Excel: Depreciation With Part-Year StartExcel Functions A–ZIMAGE Function in Excel: Put a Picture Inside a Cell
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong