Excel SEQUENCE Function

What this does

SEQUENCE produces a run of numbers as a spilled array. Because Excel stores dates as numbers, it is also the shortest way to build a date series: starting from a date and stepping by 1 gives consecutive days, which is how a calendar column or a project timeline gets built without dragging a fill handle. Its second common use is feeding other array functions — supplying the k argument to LARGE for a top-n list, or the row indices to INDEX. A step of -1 counts down. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. Treat “excel sequence function” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected formula shows up while it is still harmless. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That turns a workflow that saves repeating the same clicks every week into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

Thirty consecutive dates from a start in A1: =SEQUENCE(30, 1, A1, 1), formatted as dates. Twelve month-start dates: =EOMONTH(A1, SEQUENCE(12, 1, -1, 1))+1. A top-five list in one formula: =LARGE(B2:B500, SEQUENCE(5)). A 4×3 grid numbered 1 to 12: =SEQUENCE(4, 3). SEQUENCE replaces the drag-to-fill for any regular series, and a series that is a formula updates when its start does. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.

In Google Sheets

Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. If you take one thing from this page on “excel sequence function”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.

Common mistakes

• Forgetting to format a date sequence, which shows serial numbers.
• Generating a block larger than the empty space available, which returns #SPILL!.
• Using it in Excel 2019 or earlier, where it does not exist.

Frequently asked questions