Quick Navigation
SEQUENCE Function
Summary
The SEQUENCE function generates an array of sequential numbers, creating lists like 1, 2, 3, 4 automatically. It's perfect for quickly building number sequences, date ranges, or any patterned data without manual entry.
Syntax
SEQUENCE(rows,[columns],[start],[step])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| rows | Number |
Yes | Required. Specifies the height of the array (number of rows) |
| columns | Number |
No | Optional. Specifies the width of the array (number of columns) |
| start | Number |
No | Optional. The first number in the sequence |
| step | Number |
No | Optional. The amount to increment each subsequent number |
Using the SEQUENCE Function
SEQUENCE revolutionizes data creation by automatically generating number sequences without typing each value. Use it to create headers, sample datasets, date ranges, or any sequential pattern. The function spills dynamically, automatically expanding to fill the required space.
Common SEQUENCE Examples
Basic Vertical Sequence
=SEQUENCE(5)Generates {1;2;3;4;5} - a 5-row single column array starting at 1.
Horizontal Header Row
=SEQUENCE(1,6,2024,1)Creates 2024, 2025, 2026, 2027, 2028, 2029 across 6 columns.
2D Data Grid
=SEQUENCE(4,5)Generates a 4x5 grid: 1,2,3,4,5 / 6,7,8,9,10 / etc.
Custom Start and Step
=SEQUENCE(3,1,100,25)Creates 100, 125, 150 - vertical list with custom start and increment.
Month Headers
=TEXT(DATE(YEAR(TODAY()),SEQUENCE(1,12),1),"mmm")Generates Jan, Feb, Mar... Dec for current year.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Rows argument is zero, negative, or non-numeric
Solution: Ensure rows > 0 and all arguments are valid numbers
#SPILL! error
Cause: Output area contains data blocking the spill range
Solution: Clear the spill range or move formula
#REF! error
Cause: Source workbook closed when using across workbooks
Solution: Keep both workbooks open
Notes
- Returns dynamic array that automatically spills
- If rows omitted, must provide columns, start, or step
- Works with Excel Tables and structured references
- Perfect companion to SORT, FILTER, and UNIQUE functions
Compatibility
Available in: Excel 365, Excel 2021
Not available in: Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 365, Excel 2021