Syntax
SEQUENCE(rows, [columns], [start], [step])
| Parameter | Description |
|---|---|
| rows | Parameter of the SEQUENCE function. |
| [columns] | (Optional.) Parameter of the SEQUENCE function. |
| [start] | (Optional.) Parameter of the SEQUENCE function. |
| [step] | (Optional.) Parameter of the SEQUENCE function. |
Examples
Simple numbered list
Formula
=SEQUENCE(10)
Returns a column of numbers 1 through 10. Default start is 1, default step is 1.
Month numbers as a row
Formula
=SEQUENCE(1, 12)
Returns a single row with values 1 through 12 — useful for month headers across a budget spreadsheet.
Even numbers from 0 to 18
Formula
=SEQUENCE(10, 1, 0, 2)
Returns 0, 2, 4, 6, ..., 18. Starts at 0 and increments by 2 for 10 values.
Common Errors
#VALUE!
Rows or columns is not a positive integer, or any argument is non-numeric.
#CALC!
The resulting array would be too large to fit in the worksheet.
Tips
Generate date sequences
Use =SEQUENCE(30, 1, DATE(2026,1,1), 1) to generate 30 consecutive dates starting from January 1, 2026. Format the cells as dates.
Multiplication table
Combine with SEQUENCE in both dimensions: =SEQUENCE(10,1,1,1) * TRANSPOSE(SEQUENCE(10,1,1,1)) creates a 10x10 multiplication table.
Replaces ROW()-based tricks
Before SEQUENCE existed, people used ROW(INDIRECT("1:10")) to generate number series. SEQUENCE is cleaner, faster, and more flexible.
Try SEQUENCE in Viztab
Import your data and use SEQUENCE with 370+ other formulas. No signup required.
Open Viztab