# SEQUENCE Function in Google Sheets: Explained

In this article, you will learn how to use the SEQUENCE formula in Google Sheets.

## How does the SEQUENCE formula work in Google Sheets?

The SEQUENCE function in Google Sheets is a function that generates a sequence of numbers in the specified range based on a starting value and a step value. The SEQUENCE can be helpful in various situations where you want to generate a series of numbers with a particular pattern in Google Sheets.

## How do you use the SEQUENCE function in Google Sheets?

Here is the general syntax for the SEQUENCE function:

**rows**: The number of rows in the array.

**columns** **[Optional]**: The number of columns in the array. If not specified, the default is 1.

**start [Optional]**: The starting value for the sequence. If not specified, the default is 1.

step **[Optional]**: The increment between each value in the sequence. If not specified, the default is 1.

For example, if you wanted to generate a sequence of numbers from 1 to 10, you could use the following formula:

This would generate a 1x10 array of numbers from 1 to 10, like this:

You can also use the other three parameters, columns, start, and step arguments to customize the sequence. For example, if you wanted to generate a 2x5 array of numbers starting from 5, with a step value of 5, you could use the following formula:

This would generate a 2x5 array of numbers from 5 to 50, with a step value of 5, like this: