How to Use the SEQUENCE Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: SEQUENCE generates a list or grid of numbers. The formula is =SEQUENCE(rows, [columns], [start], [step]). =SEQUENCE(5) returns 1 to 5 down a column.

What SEQUENCE does

Numbering rows by hand or by dragging a fill handle breaks when rows move. SEQUENCE builds the list from one formula. It is useful for row numbers, test data and the number inputs of other array formulas.

SEQUENCE syntax

=SEQUENCE(rows, [columns], [start], [step])
ArgumentMeaningDefault
rowsNumber of rows to return (required)None
columnsNumber of columns to returnOne column
startThe number the sequence begins at1
stepHow much each number increases or decreasesIncreases by 1

If you leave out columns the result is a vertical list. For a horizontal list, set rows to 1 and give a column count. A negative step produces a decreasing sequence.

A step-by-step example

=SEQUENCE(5)

This returns 1, 2, 3, 4, 5 down a column. For a grid, add columns: =SEQUENCE(2, 3) returns 1, 2, 3 on the first row and 4, 5, 6 on the second. Numbers fill row by row.

=SEQUENCE(2, 3, 10, -1)

This starts at 10 and steps down by 1, giving 10, 9, 8 on the first row and 7, 6, 5 on the second.

Common mistakes

Try it yourself

Type your formula into the box, starting with =, then press Check.

Exercise 1: Five numbers

Write a formula that returns a list of the numbers 1 to 5 down a column.

Hint: only the rows argument is needed.

Exercise 2: Counting down

Write a formula that returns a grid of 2 rows and 3 columns, starting at 10 and decreasing by 1.

Hint: the step is negative.

What to learn next

Syntax and rules in this guide were checked against Google's SEQUENCE help page. See all guides.