SEQUENCE Function
Generates a list or grid of sequential numbers.
Category
Math & Trig
Available in
Microsoft 365, Excel 2021+
Returns
An array that spills
Overview
SEQUENCE builds a run of numbers — 1 to 10, every 5th number, a 4×3 grid — and spills it into the sheet.
Combined with dates, INDEX or TEXT it creates calendars, numbered lists and row counters that grow automatically.
Syntax
=SEQUENCE(rows, [columns], [start], [step])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| rows | Yes | How many rows to return. |
| columns | Optional | How many columns. Default 1. |
| start | Optional | The first number. Default 1. |
| step | Optional | The increase each time. Default 1 (negative counts down). |
Examples
Example 1 — Numbering a list
Number five rows automatically.
A2fx=SEQUENCE(5)
| A | |
|---|---|
| 1 | # |
| 2 | 1 |
| 3 | 2 |
| 4 | 3 |
| 5 | 4 |
| 6 | 5 |
=SEQUENCE(5) Explain
Example 2 — Every 250 from 1,000
Price breaks starting at 1,000, going up by 250.
A2fx=SEQUENCE(1, 4, 1000, 250)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Price breaks | |||
| 2 | 1000 | 1250 | 1500 | 1750 |
=SEQUENCE(1, 4, 1000, 250) Explain
Example 3 — The next 7 days
Spill a week of dates starting today (format as dates).
=TODAY()+SEQUENCE(7)-1 Explain
Common mistakes
- #SPILL! Cells in the way block the result. Clear them, or move the formula.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.