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.

**Additional Resources**

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

How to Use AVERAGEIFS Function in Google Sheets

How to Use ISERROR Function in Google Sheets

How to Ignore #N/A Values with Formulas in Google Sheets