You need numbers 1 to 100 in a column, or the next 30 dates in a row, or a 5 by 5 grid of test values. Typing them is slow and error-prone; dragging the fill handle works until the length changes. SEQUENCE generates the whole series in one formula that spills — change the length and the series follows.
What SEQUENCE does
SEQUENCE returns a grid of sequential numbers: rows tall, columns wide, starting where you say, stepping by what you say. With one argument it fills a column 1 to N. With dates as a start, it fills dates. It is the standard way to build row numbers, test data, and date series that stay correct when the size changes.
The syntax
=SEQUENCE(rows, [columns], [start], [step])
- rows — how many rows the series has.
- columns — how many columns. Default is 1.
- start — the first value. Default is 1.
- step — the gap between values. Default is 1; use 7 for weekly dates.
Step-by-step example
Build a 10-row numbering column and a 7-day date list.
- Click the cell where the series should start.
- Type
=SEQUENCE(10)and press Enter — the numbers 1 to 10 spill down. - For dates, type
=SEQUENCE(7,1,DATE(2026,1,5),1)in another cell — seven dates starting January 5th, 2026. - For a 5 by 3 grid, type
=SEQUENCE(5,3,100,10)— five rows, three columns, starting at 100 and stepping by 10. - To number a table that grows, point the rows at a count:
=SEQUENCE(COUNTA(A2:A100))keeps the numbers matched to the entries.
Worked example
| SEQUENCE formula | Result |
|---|---|
| =SEQUENCE(5) | 1, 2, 3, 4, 5 |
| =SEQUENCE(3,2,10,5) | 10, 15 / 20, 25 / 30, 35 |
| =SEQUENCE(7,1,DATE(2026,1,5),1) | Jan 5 – Jan 11, 2026 |
One formula replaces a column of typed numbers, and the series is always the right length because the length is an argument, not a drag distance.
Common errors
#SPILL! — no room for the series. The spill needs empty cells below (and right, for multi-column series). Clear the area first.
The series starts at 0. The start argument defaults to 1 only when omitted — if you passed 0, you asked for 0. Set start to 1 explicitly.
Dates show as numbers. A date series spills serial numbers until the cells are formatted as dates. Select the spill and apply a date format.
It counts the header row. SEQUENCE(COUNTA(A:A)) counts the header too. Subtract 1, or count from A2: =SEQUENCE(COUNTA(A2:A100)).
Tip
SEQUENCE is the building block for test data: =SEQUENCE(100) gives 100 row numbers, and =RANDARRAY(100,1,1,100,TRUE) next to it gives 100 random values. Together they generate a realistic test table in two formulas. One more use: numbering the rows of a filtered result, where a plain typed 1,2,3 would break the moment the filter changes.
SEQUENCE with other functions
SEQUENCE shines inside other formulas. =INDEX(A2:A50,SEQUENCE(5)) returns the first five items of a list, and =SUM(SEQUENCE(10)) is 55 — the sum of 1 to 10, no helper column needed. For invoice numbers, ="INV-"&TEXT(SEQUENCE(20,1,1001,1),"0000") spills INV-1001 through INV-1020, each formatted with leading zeros. Whenever a task starts with “I need numbers 1 to N”, SEQUENCE is the first function to reach for, and it usually replaces the whole manual setup.
Practice file
Download the SEQUENCE practice file (.xlsx) — it contains live SEQUENCE formulas for numbering, dates, and a grid, plus a blank sheet for you to try it yourself.
Google Sheets
Google Sheets has SEQUENCE with the same syntax and the same spill behaviour. One Sheets difference: the spilled range can be referenced with the # operator (for example A2#) in later formulas, which works in Excel too.
Example prices and figures are illustrative, not market data.