{"id":406,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/sequence\/"},"modified":"2021-02-13T11:36:19","modified_gmt":"2021-02-13T11:36:19","slug":"sequence","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/sequence\/","title":{"rendered":"SEQUENCE"},"content":{"rendered":"

In this article, we will delve into the SEQUENCE function, which is available in both Microsoft Excel and Google Sheets. The SEQUENCE function is a powerful dynamic array feature that generates a list of sequential numbers across rows and\/or columns. It is particularly useful for creating numerical series that increase by a set increment.<\/p>\n

Basic Syntax<\/h2>\n

The syntax for the SEQUENCE function is consistent in both Excel and Google Sheets:<\/p>\n

=SEQUENCE(rows, [columns], [start], [step])<\/code><\/pre>\n
    \n
  • rows:<\/strong> Specifies the number of rows for the sequence.<\/li>\n
  • columns:<\/strong> (Optional) Specifies the number of columns for the sequence. The default value is 1 if this argument is omitted.<\/li>\n
  • start:<\/strong> (Optional) Determines the starting number of the sequence. By default, it begins at 1 if not specified.<\/li>\n
  • step:<\/strong> (Optional) The incremental value between each sequential number. If this is omitted, the default increment is 1.<\/li>\n<\/ul>\n
    Examples<\/h2>\n
    Creating a Simple Sequence<\/h2>\n
    Let us begin by creating a straightforward sequence of numbers from 1 to 10 in a single column:<\/p>\n\n\n\n
    Excel<\/th>\nGoogle Sheets<\/th>\n<\/tr>\n
    \n
    =SEQUENCE(10)<\/code><\/pre>\n<\/td>\n
    		\n
    =SEQUENCE(10)<\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n
    Creating a Sequence with Custom Start and Step Values<\/h2>\n
    Now, let’s craft a sequence that starts at 5, increases by 2, and spans 5 rows:<\/p>\n\n\n\n
    Excel<\/th>\nGoogle Sheets<\/th>\n<\/tr>\n
    \n
    =SEQUENCE(5, , 5, 2)<\/code><\/pre>\n<\/td>\n
    		\n
    =SEQUENCE(5, 1, 5, 2)<\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n
    Creating a Matrix of Sequential Numbers<\/h2>\n
    To generate a matrix of sequential numbers, we simply specify the desired number of rows and columns. Here is an example where we create a 3×3 matrix starting from 1:<\/p>\n\n\n\n
    Excel<\/th>\nGoogle Sheets<\/th>\n<\/tr>\n
    \n
    =SEQUENCE(3, 3)<\/code><\/pre>\n<\/td>\n
    		\n
    =SEQUENCE(3, 3)<\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n
    These examples demonstrate the versatility of the SEQUENCE function for rapidly generating sequential numbers in both Excel and Google Sheets. Try adjusting the function’s parameters to tailor the output to your specific needs in your worksheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Generates a list of sequential numbers in an array, such as 1, 2, 3, 4<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[198],"tags":[],"class_list":["post-406","post","type-post","status-publish","format-standard","hentry","category-math-and-trigonometry"],"acf":[],"yoast_head":"\nExcel SEQUENCE Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel SEQUENCE function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/sequence\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel SEQUENCE Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel SEQUENCE function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/sequence\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:36:19+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel SEQUENCE Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/sequence\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/sequence\/\",\"name\":\"Excel SEQUENCE Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:36:19+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel SEQUENCE function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/sequence\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/sequence\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/sequence\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Math and trigonometry\",\"item\":\"https:\/\/functiontranslator.com\/en\/math-and-trigonometry\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SEQUENCE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel SEQUENCE Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel SEQUENCE function does. Clear syntax explanation and useful formula examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/en\/sequence\/","og_locale":"en_US","og_type":"article","og_title":"Excel SEQUENCE Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel SEQUENCE function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/sequence\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:36:19+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel SEQUENCE Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/sequence\/","url":"https:\/\/functiontranslator.com\/en\/sequence\/","name":"Excel SEQUENCE Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:36:19+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel SEQUENCE function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/sequence\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/sequence\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/sequence\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Math and trigonometry","item":"https:\/\/functiontranslator.com\/en\/math-and-trigonometry\/"},{"@type":"ListItem","position":3,"name":"SEQUENCE"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/406","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=406"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/406\/revisions"}],"predecessor-version":[{"id":3297,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/406\/revisions\/3297"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}