# Google Sheets: How to Use SEQUENCE Function

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:

The result is a single row that contains the sequential values 1 through 5.

### 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 here.