# SEQUENCE

#### Syntax 1 <a href="#syntax.47" id="syntax.47"></a>

**SEQUENCE**(*range*)

* *range* - a range that is to be filled with sequential numbers - ***Value type**: widget*

Returns a range with the same number of rows and columns as *range*, filled with a sequence of integers, starting from 1. The integers are incremented row-by-row.

**Syntax 2**

**SEQUENCE**(*numRows;* *numColumns*)

* *numRows* - the number of rows of the result range - ***Value type**: number*
* *numColumns* - the number of columns of the result range - ***Value type**: number*

Returns a range with *numRows* and *numColumns*, with a sequence of integer values, starting from 1, up to *numRows* x *numColumns*.

#### Remarks

* The maximum amount of cells which can be created by the SEQUENCE function is 100,000
* Each parameter allows a maximum value of 9,999.

#### Examples <a href="#examples.11" id="examples.11"></a>

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-dc5d1bb6dd99c6df03c1a8ce8754e8390cee9be4%2Fimage.png?alt=media" alt=""><figcaption></figcaption></figure>

<div align="left"><figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-29163708a41a79798dc9d22dd23c913e00618035%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure></div>

<div align="left"><figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-9136225d1271f43950760bbc1c2cb4803535c186%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure></div>