This page isn't translated yet, so its text is in English. Function names and formulas are shown in your Excel language.
Excel function · Dynamic arrays
SEQUENCE
Returns a list of numbers in a sequence, such as 1, 2, 3.
What it does
SEQUENCE fills a block of cells with numbers that go up in steps. You choose the number of rows and columns, the first number and the step. It replaces typing a list or dragging the fill handle.
Syntax
=SEQUENCE(rows; [columns]; [start]; [step])Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ;
Arguments
- rows
- How many rows to fill.
- columns
- How many columns to fill. Left out, 1.
- start
- The first number. Left out, 1.
- step
- How much each number goes up. Left out, 1; a negative step counts down.
Example
Tables at an event are numbered 10, 20, 30 and 40. How do you make that list?
| A | |
|---|---|
| 1 | Table no. |
| 2 | 10 |
| 3 | 20 |
| 4 | 30 |
| 5 | 40 |
The formula in A2:
=SEQUENCE(4;1;10;10)The result spills into the cells below: 10; 20; 30; 40
4 rows and 1 column, starting at 10 and going up by 10: 10, 20, 30, 40.
Common mistakes
- Swapping rows and columns.
SEQUENCE(1,4) fills a row, not a column. - Expecting a fixed list. The numbers are a formula result; to keep them, copy and paste as values.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | SEQUENCE | , |
| Deutsch | SEQUENZ | ; |
| Français | SEQUENCE | ; |
| Español (España) | SECUENCIA | ; |
| Español (México) | SECUENCIA | , |
| 日本語 | SEQUENCE | , |
| 한국어 | SEQUENCE | , |
| 繁體中文 | SEQUENCE | , |
| ไทย | SEQUENCE | , |
| ខ្មែរ | SEQUENCE | , |
| Tiếng Việt | SEQUENCE | ; |