How to Use SEQUENCE Function in Google Sheets?

---

You can use the SEQUENCE function in Google Sheets to return an array of sequential numbers.

This function uses the following basic syntax:

SEQUENCE(rows, columns, start, step)

where:

• rows: The number of rows to return
• columns: The number of columns to return (default is 1)
• start: The number to start the sequence at (default is 1)
• step: The amount to increase or decrease each number in the sequence (default is 1)

The following examples show to use this function in different scenarios in Google Sheets.

Example 1: Create Sequence of Values in One Column

We can use the following formula to create a sequence of values in one column:

SEQUENCE(10)

The following screenshot shows how to use this formula in practice:

The result is a single column that contains the sequential values 1 through 10.

Example 2: Create Sequence of Values in One Row

We can use the following formula to create a sequence of values in one row:

SEQUENCE(1, 5)

The following screenshot shows how to use this formula in practice:

Example 3: Create Matrix of Sequential Values

We can use the following formula to create a matrix of values with 10 rows, 3 columns, starts at 0, and increases each value by 5:

SEQUENCE(10, 3, 0, 5)

The following screenshot shows how to use this formula in practice:

The result is a matrix with 10 rows, 3 columns, starts at 0, and increases each value by 5.

Note: You can find the complete documentation for the SEQUENCE function in Google Sheets .

The following tutorials explain how to use other common functions in Google Sheets: