Excel SEQUENCE Function (Generated Grid) – Examples & Practice
Practice the Excel SEQUENCE function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Generate a 5-row, 1-column sequence starting at 1 with step 1.
Formula Syntax
=SEQUENCE(rows, [columns], [start], [step])
- rows: How many rows to spill.
- [columns]: Optional columns (default 1).
- [start]: Optional starting value (default 1).
- [step]: Optional increment (default 1).
What it does
SEQUENCE generates a grid of sequential numbers with a configurable start and step. It is a building block for dynamic calendars, indexes, and simulation rows.
Excel SEQUENCE Function Examples
One column of 1..5
=SEQUENCE(5)
Spills five rows starting at 1 with step 1.
3×4 grid starting at 10, step 2
=SEQUENCE(3, 4, 10, 2)
Creates a small matrix of even numbers starting at 10.
Row labels for a table
=SEQUENCE(COUNTA(A2:A100), 1, 1, 1)
Builds indexes as tall as your populated rows (watch blanks in COUNTA).
dynamic-array-data.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Category | Amount | Region |
| 2 | A | 120 | North |
| 3 | B | 340 | South |
| 4 | A | 560 | North |
| 5 | C | 225 | West |
| 6 | B | 90 | South |
| 7 | Output |
Input Formula
Need Help?
Tips
- Prefer bounded heights tied to COUNTA on real tables.
- Pair with **FILTER** and **SORT** for complete mini-ETL.
- Document units (days vs months) when mixing with dates.
SEQUENCE Function Use Cases
- Calendar scaffolding and period indexes
- Monte Carlo row generators with RANDARRAY
- Teaching array thinking before complex models
- Temporary keys for Power Query staging
- Replace fragile fill-handle lists
Common mistakes - SEQUENCE function not working
- COUNTA off-by-one with headers included
- Step/start arguments reversed
- Spill blocked by formatting or values
- Huge row counts created accidentally
- Mixing SEQUENCE with pre-dynamic Excel
FAQ
Does SEQUENCE spill?
Yes. It fills rows and columns starting at the formula cell in dynamic Excel.
Can SEQUENCE start at zero?
Yes. Set the start argument to 0 when you need zero-based indexes.
SEQUENCE vs ROW()-ROW($1$1)?
SEQUENCE is clearer for explicit grids; legacy formulas often used ROW tricks.
Can I use SEQUENCE inside DATE?
Yes—common for building a column of month serials when combined with EDATE/EOMONTH patterns.
Why #SPILL!?
The output rectangle overlaps non-empty cells or merged areas.
Comparison
| Tool | Output |
|---|---|
| SEQUENCE | Numeric grid |
| ROW/COLUMN | Position on sheet |
| RANDARRAY | Random grid |
Example
=SEQUENCE(5,1,1,1)=SEQUENCE(3, 4, 10, 2)
Advanced examples
SEQUENCE + DATE month list
Combine DATE, EDATE, or EOMONTH patterns to turn indexes into readable month headers.
SEQUENCE as indices for INDEX
=INDEX(B:B, SEQUENCE(10)+5) pulls ten values starting below row 5—use bounded ranges in production.