---
title: "SEQUENCE function in Excel: syntax and examples | PracticeExcel"
description: "How to use SEQUENCE in Excel 365 and Google Sheets: number rows, build grids of numbers and lists that count by 5s or 10s."
canonical_url: "https://practiceexcelonline.com/functions/sequence"
locale: en
meta:
  "og:description": "How to use SEQUENCE in Excel 365 and Google Sheets: number rows, build grids of numbers and lists that count by 5s or 10s."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U0VRVUVOQ0UgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBTRVFVRU5DRSBpbiBFeGNlbCAzNjUgYW5kIEdvb2dsZSBTaGVldHM6IG51bWJlciByb3dzLCBidWlsZCBncmlkcyBvZiBudW1iZXJzIGFuZCBsaXN0cyB0aGF0IGNvdW50IGJ5IDVzIG9yIDEwcy4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~U0VRVUVOQ0Uocm93cywgW2NvbHVtbnNdLCBbc3RhcnRdLCBbc3RlcF0p%2Cp_Ii9mdW5jdGlvbnMvc2VxdWVuY2Ui%2Cs_F0R9ax52gaM7rEY7.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "SEQUENCE function in Excel: syntax and examples | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U0VRVUVOQ0UgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBTRVFVRU5DRSBpbiBFeGNlbCAzNjUgYW5kIEdvb2dsZSBTaGVldHM6IG51bWJlciByb3dzLCBidWlsZCBncmlkcyBvZiBudW1iZXJzIGFuZCBsaXN0cyB0aGF0IGNvdW50IGJ5IDVzIG9yIDEwcy4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~U0VRVUVOQ0Uocm93cywgW2NvbHVtbnNdLCBbc3RhcnRdLCBbc3RlcF0p%2Cp_Ii9mdW5jdGlvbnMvc2VxdWVuY2Ui%2Cs_F0R9ax52gaM7rEY7.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)

# **The SEQUENCE function**

Returns a list of numbers in sequence, such as 1, 2, 3, that spills into rows and columns. You choose the size, the start and the step.

=

SEQUENCE(

## **Syntax**

```
SEQUENCE(rows, [columns], [start], [step])
```

<dl><dt>**rows **</dt>
<dd>How many rows to fill.</dd>
<dt>**columns **(optional)</dt>
<dd>How many columns to fill. Left out, 1.</dd>
<dt>**start **(optional)</dt>
<dd>The first number. Left out, 1.</dd>
<dt>**step **(optional)</dt>
<dd>How much each number goes up by. Left out, 1. A negative step counts down.</dd></dl>

## **Examples**

B1=SEQUENCE(5)

|  | A | B |
| --- | --- | --- |
| 1 |  | **1** |
| 2 |  | **2** |
| 3 |  | **3** |
| 4 |  | **4** |
| 5 |  | **5** |

B1`=SEQUENCE(<sup>1</sup>2,<sup>2</sup>3,<sup>3</sup>10,<sup>4</sup>10)`

|  | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 |  | **10** | **20** | **30** |
| 2 |  | **40** | **50** | **60** |

**In plain words:** Fill <sup>1</sup>2 rows and <sup>2</sup>3 columns, <sup>3</sup>starting at 10 and <sup>4</sup>counting up by 10.

B1=SUM(SEQUENCE(100))

|  | A | B |
| --- | --- | --- |
| 1 |  | **5050** |

## **Questions**

<details>

<summary>

### How do I number a list that keeps growing?

</summary>

Count the filled cells and let SEQUENCE spill that many numbers, as in =SEQUENCE(COUNTA(B2:B100)). Add a name to the list and the numbering grows with it.

</details>

<details>

<summary>

### Why does SEQUENCE return

</summary>

The cells it needs are not empty. SEQUENCE(5) needs five free cells down from the formula; clear them and the numbers appear.

</details>

## **Related functions**

- [**ROW**](https://practiceexcelonline.com/functions/row)
- [**INDEX**](https://practiceexcelonline.com/functions/index)
- [**SORT**](https://practiceexcelonline.com/functions/sort)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/functions/sequence#webpage","description":"How to use SEQUENCE in Excel 365 and Google Sheets: number rows, build grids of numbers and lists that count by 5s or 10s.","name":"SEQUENCE function in Excel: syntax and examples","url":"https://practiceexcelonline.com/functions/sequence","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/functions/sequence#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/functions/sequence#/schema/question/1"},{"@id":"https://practiceexcelonline.com/functions/sequence#/schema/question/2"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/functions/sequence"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/functions/sequence#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://practiceexcelonline.com/functions","position":2},{"@type":"ListItem","name":"SEQUENCE function in Excel: syntax and examples","position":3}]},{"@id":"https://practiceexcelonline.com/functions/sequence#article","description":"How to use SEQUENCE in Excel 365 and Google Sheets: number rows, build grids of numbers and lists that count by 5s or 10s.","headline":"SEQUENCE function in Excel: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U0VRVUVOQ0UgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBTRVFVRU5DRSBpbiBFeGNlbCAzNjUgYW5kIEdvb2dsZSBTaGVldHM6IG51bWJlciByb3dzLCBidWlsZCBncmlkcyBvZiBudW1iZXJzIGFuZCBsaXN0cyB0aGF0IGNvdW50IGJ5IDVzIG9yIDEwcy4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~U0VRVUVOQ0Uocm93cywgW2NvbHVtbnNdLCBbc3RhcnRdLCBbc3RlcF0p%2Cp_Ii9mdW5jdGlvbnMvc2VxdWVuY2Ui%2Cs_F0R9ax52gaM7rEY7.png","@type":["Article","TechArticle"],"author":{"@id":"https://practiceexcelonline.com/#identity"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/functions/sequence#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/functions/sequence#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/functions/sequence#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I number a list that keeps growing?","acceptedAnswer":{"@type":"Answer","text":"Count the filled cells and let SEQUENCE spill that many numbers, as in =SEQUENCE(COUNTA(B2:B100)). Add a name to the list and the numbering grows with it."}},{"@id":"https://practiceexcelonline.com/functions/sequence#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Why does SEQUENCE return","acceptedAnswer":{"@type":"Answer","text":"The cells it needs are not empty. SEQUENCE(5) needs five free cells down from the formula; clear them and the numbers appear."}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U0VRVUVOQ0UgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBTRVFVRU5DRSBpbiBFeGNlbCAzNjUgYW5kIEdvb2dsZSBTaGVldHM6IG51bWJlciByb3dzLCBidWlsZCBncmlkcyBvZiBudW1iZXJzIGFuZCBsaXN0cyB0aGF0IGNvdW50IGJ5IDVzIG9yIDEwcy4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~U0VRVUVOQ0Uocm93cywgW2NvbHVtbnNdLCBbc3RhcnRdLCBbc3RlcF0p%2Cp_Ii9mdW5jdGlvbnMvc2VxdWVuY2Ui%2Cs_F0R9ax52gaM7rEY7.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U0VRVUVOQ0UgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBTRVFVRU5DRSBpbiBFeGNlbCAzNjUgYW5kIEdvb2dsZSBTaGVldHM6IG51bWJlciByb3dzLCBidWlsZCBncmlkcyBvZiBudW1iZXJzIGFuZCBsaXN0cyB0aGF0IGNvdW50IGJ5IDVzIG9yIDEwcy4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~U0VRVUVOQ0Uocm93cywgW2NvbHVtbnNdLCBbc3RhcnRdLCBbc3RlcF0p%2Cp_Ii9mdW5jdGlvbnMvc2VxdWVuY2Ui%2Cs_F0R9ax52gaM7rEY7.png"}]}
```

## Sitemap

See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.