How to Use SEQUENCE in Excel
Generates a series of numbers in one formula — build calendars, month numbers and test data instantly.
What is SEQUENCE in Microsoft Excel?
SEQUENCE produces a rectangular array of numbers starting wherever you like and stepping by any amount. It replaces dragging a fill handle down thousands of rows. Combined with DATE and EDATE it becomes a date generator; combined with RANDARRAY it builds sample datasets.
Formula Syntax
Arguments Breakdown
| Argument | Requirement | Purpose & Details |
|---|---|---|
| rows | Required | How many rows the sequence should span. |
| columns | Optional | How many columns. Defaults to 1. |
| start | Optional | The first number. Defaults to 1. |
| step | Optional | The increment between values. Defaults to 1. |
When to Use SEQUENCE (Real-World Business Scenarios)
- 1
Generating month numbers 1 to 12 for a report skeleton.
- 2
Building a list of dates with =SEQUENCE(30,1,DATE(2026,11,1),1).
- 3
Creating numbered rows for a helper column without dragging.
Step-by-Step Practical Business Example
Suppose you have the following dataset in Excel cells A1:D4:
| Month No | Month Name | Period Start |
|---|---|---|
| 1 | Jan | 2026-01-01 |
| 2 | Feb | 2026-02-01 |
| 3 | Mar | 2026-03-01 |
How it works: SEQUENCE(12) generates 1 to 12, EDATE shifts the base date by that many months, and TEXT formats each result as a short month name.
Common Errors & How to Fix Them
Why it happens: The output area is blocked by existing values.
Fix: Clear the cells below the formula, or reduce the rows argument.
Why it happens: rows or columns was set to 0 or a negative number.
Fix: Both dimensions must be at least 1.
Try SEQUENCE Live in Your Browser
No need to launch desktop Excel. Practice formulas with real-time feedback in our HyperFormula sandbox.
Frequently Asked Questions (SEQUENCE)
What does the SEQUENCE formula do in Excel?
SEQUENCE produces a rectangular array of numbers starting wherever you like and stepping by any amount. It replaces dragging a fill handle down thousands of rows. Combined with DATE and EDATE it becomes a date generator; combined with RANDARRAY it builds sample datasets.
What is the syntax for SEQUENCE?
What are common mistakes when using SEQUENCE?
#SPILL!: The output area is blocked by existing values. (Clear the cells below the formula, or reduce the rows argument.) #VALUE!: rows or columns was set to 0 or a negative number. (Both dimensions must be at least 1.)
Related Excel Formulas
Keep building your formula toolkit with these dynamic arrays functions.
- LETAssigns names to calculation results within a formula, boosting calculation performance and readability.
- UNIQUEExtracts an automatically spilling list of unique, deduplicated values from any column or range.
- FILTERFilters a range of data dynamically based on criteria and spills the matching records automatically.
- SORTReturns a sorted copy of a range as a spilled array, leaving the original data untouched.
- VSTACKStacks several ranges on top of each other into one continuous list — the clean fix for monthly files.
- XLOOKUPThe modern, versatile replacement for VLOOKUP and HLOOKUP that searches in any direction without column index numbers.
Master SEQUENCE in Advanced Excel
Learn SEQUENCE along with our formula library, practice files, and verifiable certificates in our complete curriculum.