Excel SEQUENCE Shortcut: Fast Ways to Create a Series

Excel has no dedicated keyboard shortcut for the SEQUENCE function. In Microsoft 365 or Excel 2021 and later, type a formula such as =SEQUENCE(5) in an empty cell and press Enter to create a vertical series from 1 to 5; for a keyboard-driven alternative, use the Fill Series command with the Windows key sequence Alt, H, F, I, S.

What the SEQUENCE shortcut question means

People asking for an “Excel SEQUENCE shortcut” may mean one of two things: a shortcut to insert the SEQUENCE function, or a quick way to generate consecutive values without typing them one at a time. Excel does not assign SEQUENCE its own keyboard shortcut. The quickest method depends on whether you want a formula that updates and spills automatically, or a fixed series of values.

SEQUENCE is a worksheet function, not a command in the ribbon. Enter it in a cell, specify how many rows and columns you want, and Excel returns the requested array. On Windows desktop Excel, Alt, H, F, I, S is a ribbon Key Tips sequence for opening the Series command through Home > Fill > Series. Press the keys in order rather than all at once. Key Tips can vary with Excel version, language, or ribbon configuration, so the visible letters on screen are the final guide.

How SEQUENCE works

The syntax is =SEQUENCE(rows,[columns],[start],[step]). Rows is required; the other arguments are optional. Rows and columns set the shape of the returned array, start sets its first value, and step determines the change from one value to the next. If you leave out columns, start, or step, Excel uses 1 for each omitted argument.

With cell A1 empty and selected, enter =SEQUENCE(5). The formula returns five values vertically: 1, 2, 3, 4, and 5 in A1:A5. Only A1 contains the formula; Excel displays the other values in the cells below as a spilled array. Press Enter to confirm it. In supported versions, Ctrl+Shift+Enter is not needed for this dynamic-array formula.

To create a horizontal sequence, with A1 empty, enter =SEQUENCE(1,5,10,2). The result across A1:E1 is 10, 12, 14, 16, 18. The arguments mean one row, five columns, a starting value of 10, and a step of 2. Negative steps work too: with A1 empty, =SEQUENCE(4,1,10,-2) returns 10, 8, 6, and 4 down A1:A4.

Choosing a formula or the Fill Series shortcut

Use SEQUENCE when you want the values to remain linked to a formula and recalculate if you change its arguments. Use Fill Series when you want Excel to write a series into a selected range, especially if you do not need a live formula. Both approaches can create numbers, but their results behave differently when the starting value, range, or worksheet changes.

Use SEQUENCE for a dynamic list whose length or starting point you may revise. Change the formula arguments and the spilled results update.
Use Fill Series for a one-time, fixed run of values. It writes values into the cells rather than leaving a SEQUENCE formula in the first cell.
Use the fill handle for a quick series when you can enter a starting value or sample pattern and drag to the desired range.

For Fill Series on Windows, select the range to populate, then choose Home > Fill > Series. The dialog lets you choose rows or columns, a linear or growth series, a date unit when appropriate, and a step or stop value. The Alt, H, F, I, S key sequence opens that command through ribbon Key Tips in many Windows desktop installations. It is a route to the Series dialog, not a shortcut that directly inserts SEQUENCE.

For example, type 1 in A1, select A1:A10, and open the Series dialog. Choose Columns and Linear, leave the step value at 1, and click OK. Excel fills A1:A10 with 1 through 10. If you need a different increment, set the step value accordingly. The dialog’s stop value can also limit a series, but the selected cells and series settings should be checked before confirming.

Using the fill handle and familiar shortcuts

The fill handle is the small square at the bottom-right corner of a selected cell or range. Enter a starting number, point to the handle, and drag down or across to fill neighboring cells. Dragging one numeric value may copy it rather than create a counting series, depending on the action and Excel’s AutoFill behavior. To make the intended pattern clear, enter two starting values, select both, and drag; for example, select 1 and 2, then drag to continue 3, 4, and so on.

Ctrl+D is the Windows shortcut for Fill Down: select a range that includes the source cell at the top, then press Ctrl+D to copy its contents down. It is not a general “make a sequence” shortcut. If the top cell contains the number 1, Ctrl+D generally repeats 1; it does not infer that the next value should be 2. The Mac equivalent is commonly Command+D for Fill Down, although keyboard behavior can depend on the Excel for Mac version and system settings.

On Mac, use the ribbon or fill handle rather than expecting the Windows Alt Key Tips sequence to work. Ribbon layout and keyboard access differ from Windows, and there is no universal Mac keystroke equivalent for Alt, H, F, I, S. Excel for the web also supports SEQUENCE in Microsoft 365, but ribbon access and browser keyboard shortcuts may differ. If a shortcut is intercepted by the browser or operating system, enter the formula directly or use the on-screen ribbon command.

Creating sequences for dates and custom patterns

SEQUENCE returns numbers, and Excel stores dates as serial numbers. You can use a date as the starting value and then format the spilled cells as dates. With A1 empty, enter =SEQUENCE(7,1,DATE(2026,1,1),1). The result is seven consecutive date serials beginning January 1, 2026; apply a date format to A1:A7 to display them as calendar dates. The final displayed dates depend on the cell format, not on a special date-only version of SEQUENCE.

For a weekday-only calendar, a simple SEQUENCE increment of 1 will include weekends. You would need additional date logic to skip them, so do not assume that the Fill Series date option or SEQUENCE automatically removes Saturdays and Sundays. Similarly, a sequence of month starts or business days requires a suitable formula or a deliberate fill pattern; plain increments count by the step you provide.

Custom numeric patterns are straightforward when the difference is constant. For instance, with A1 empty, =SEQUENCE(6,1,3,3) returns 3, 6, 9, 12, 15, and 18. A repeating pattern such as 1, 2, 1, 2 is not a simple linear sequence; use a different formula or enter a sample pattern and use AutoFill. Matching the method to the pattern prevents a common surprise: Excel will continue a trend only when the selected values or command make that trend clear.

Version support and dynamic-array behavior

SEQUENCE is available in Microsoft 365 and Excel 2021 or later, including supported Excel for the web editions. It is not available as a worksheet function in older perpetual releases such as Excel 2019. If Excel returns a #NAME? error for SEQUENCE, check the installed version and whether the function name is recognized in that edition. For older versions, use Fill Series, the fill handle, or a copied-down formula instead.

Dynamic arrays need clear space for their results. If any cell in the spill range contains data, Excel displays #SPILL! rather than overwriting that content. Clear or move the blocking cells, and make sure the required rows or columns are available. A spill formula also cannot spill from inside an Excel table; place the formula outside the table, or use a non-spill approach within the table.

Another important distinction is that the formula itself is stored only in the upper-left cell of the result. You can edit the formula there, but you cannot independently change one of the displayed spill values without changing the formula or breaking the spill. If you need a static list, copy the results and use Paste Special > Values. That converts the displayed sequence to fixed values, so later changes to the original formula will not update the pasted list.

Alternatives for older Excel versions

In a version without SEQUENCE, a copied-down ROWS formula can create a simple numbered list. With a formula entered in A1 and copied down, =ROWS($A$1:A1) returns 1 in A1, 2 in A2, 3 in A3, and continues as you fill it. The expanding endpoint is what makes each copied formula count the number of rows from the fixed starting reference to its current row.

For a fixed series, Home > Fill > Series is often more direct than writing a formula. For an ad hoc list, enter two starting values and drag the fill handle. These methods are useful even in current Excel, but unlike SEQUENCE they do not create a single dynamic-array formula that controls the whole result. Choose the one that best fits whether you need recalculation, a fixed output, or a quick manual fill.

Frequently Asked Questions

What is the keyboard shortcut for SEQUENCE in Excel?
There is no dedicated shortcut that inserts the SEQUENCE function. Type a formula such as =SEQUENCE(10) in an empty cell and press Enter. On Windows, Alt, H, F, I, S opens the Fill Series command in many desktop versions, which is a separate way to create fixed values.

Does Ctrl+Shift+Enter work for SEQUENCE?
It is not required in Excel 2021 or Microsoft 365. Enter the formula with Enter, and Excel spills the array into neighboring cells. Ctrl+Shift+Enter is associated with legacy array-formula entry and is not the normal way to enter a dynamic-array formula.

Why do I get #SPILL! from SEQUENCE?
One or more cells where the results need to appear are occupied, merged, or otherwise blocking the spill. Check the intended output area, remove or move the obstruction, and enter the formula again if necessary. Excel can identify the blocked range when you select the error cell.

Can I use SEQUENCE in Excel 2019?
No. SEQUENCE requires Microsoft 365 or Excel 2021 and later. In Excel 2019, create a series with Home > Fill > Series, drag the fill handle, or use a formula such as =ROWS($A$1:A1) and copy it down.

How do I make SEQUENCE go across columns?
Set the rows argument to 1 and specify the number of columns. For example, with A1 empty, =SEQUENCE(1,5) returns 1, 2, 3, 4, and 5 across A1:E1. Add start and step arguments if the series should begin somewhere else or use a different increment.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.