How to Use SEQUENCE Function in Excel - Practical Guide

Learn to use the SEQUENCE function to automatically generate arrays of sequential numbers in rows and columns. This dynamic function eliminates manual number entry and is essential for creating number ranges, ID sequences, and index columns efficiently in modern Excel workflows.

Why This Matters

SEQUENCE saves time by automatically generating number ranges instead of manual entry, and integrates seamlessly with other formulas for dynamic data generation and array operations.

Prerequisites

•Basic understanding of Excel formulas and cell references
•Excel 365 or Excel 2021+ (SEQUENCE is not available in older versions)
•Familiarity with array formulas

Step-by-Step Instructions

Open Excel and select a cell

Launch Excel and click on any empty cell where you want your sequence to start (e.g., cell A1).

Type the SEQUENCE formula

Enter the basic formula: =SEQUENCE(rows, [columns], [start], [step]). For example, =SEQUENCE(5) generates numbers 1-5 vertically.

Define the number of rows

Replace 'rows' with the desired count; this is the only required parameter. For 10 sequential numbers, use =SEQUENCE(10).

Add optional parameters

Specify columns (e.g., 3 for a 5×3 grid), starting value (e.g., 100), and step increment (e.g., 2 for even numbers) as needed.

Press Enter and view results

Press Enter to execute the formula; Excel automatically fills the spilled range with your generated sequence.

Alternative Methods

Using Fill Series

Manually select cells and use Home > Fill > Series to create sequences. This method is slower and requires pre-selection but works in all Excel versions.

ROW() and COLUMN() functions

Combine ROW() and COLUMN() functions to generate sequences without SEQUENCE. This requires helper columns and is less efficient than SEQUENCE.

Tips & Tricks

✓Use SEQUENCE(10,1,1,2) to generate even numbers: 2, 4, 6, 8, etc.
✓Combine SEQUENCE with other functions like SUM(SEQUENCE(5)) to sum 1+2+3+4+5 instantly.
✓SEQUENCE respects spill ranges; avoid blocking cells below your formula for clean results.

Pro Tips

★Nest SEQUENCE inside CHAR() to generate alphabetic sequences: =CHAR(64+SEQUENCE(26)) creates A through Z.
★Use SEQUENCE with FILTER or SORT to create dynamic lookup tables that auto-update based on criteria.
★Combine SEQUENCE(rows, columns) with INDEX() to create multi-dimensional reference tables automatically.

Troubleshooting

Formula returns #VALUE! error

Check that you've included the required 'rows' parameter and that all parameters are positive integers. Ensure Excel version is 365 or 2021+.

Results are spilling into unwanted cells

Clear cells below your formula or use a dynamic named range. Alternatively, use Ctrl+Shift+Enter if spilling isn't automatic.

SEQUENCE not recognized in formula bar

Verify you're using Excel 365 or 2021+. Update Excel or use Fill Series as an alternative in older versions.

Related Excel Formulas

FILTER SORT RANDARRAY INDEX ROW COLUMN

Frequently Asked Questions

Can SEQUENCE generate letters instead of numbers?

Not directly, but you can combine it with CHAR() or SUBSTITUTE() functions to convert numbers to letters. For example, =CHAR(64+SEQUENCE(26)) generates A-Z.

What versions of Excel support SEQUENCE?

SEQUENCE is available in Excel 365, Excel 2021, and later versions. It is not available in Excel 2019 or earlier.

Can I use SEQUENCE to create a grid of numbers?

Yes! Use =SEQUENCE(rows, columns) to create a 2D array. For example, =SEQUENCE(3,4) creates a 3-by-4 grid numbered 1-12.

How do I generate numbers in reverse order?

Use a negative step value with an appropriate starting number. For example, =SEQUENCE(5,1,5,-1) generates 5, 4, 3, 2, 1.