Fix the #NAME? Error for the SEQUENCE Function in Excel
Question details
The user needs to understand why Excel returns #NAME? for SEQUENCE and how to create a sequence in their version.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook uses the SEQUENCE function to generate a series of numbers.
- Observed behavior
- The SEQUENCE formula returns #NAME?, which may mean the installed Excel version does not recognize the function.
Select the cell showing #NAME? and check the formula bar for a misspelled function name. Note which version of Excel you are using and whether you can update it.
Check and update your Excel version
Use a version of Excel that supports SEQUENCE, or update Microsoft 365 if the function is missing.
In Excel for Windows, open File > Account and look under Product Information. On a Mac, choose Excel > About Excel.
In a blank cell, enter =SEQUENCE(3). If Excel returns #NAME?, check the spelling; the installed version may not support the function. You can also check whether FILTER or XLOOKUP is available.
In Microsoft 365 for Windows, go to File > Account > Update Options > Update Now. On a Mac, choose Help > Check for Updates. If your edition does not support SEQUENCE, use a supported edition such as Microsoft 365, Excel 2021 or later, or Excel for the web.
Reopen the workbook in the updated or supported version and select the SEQUENCE formula cell to confirm that it produces the expected numbers.

Replace SEQUENCE with a helper formula
Use this approach to create a numbered column in an older Excel version that does not recognize SEQUENCE.
Create Numbered Lists in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open an Excel workbook and use a helper formula and fill handle to create a numbered list without relying on SEQUENCE. Its Excel format support makes it easy to bring existing files into WPS.

Frequently Asked Questions
What does #NAME? mean in a SEQUENCE formula?
It usually means Excel does not recognize something in the formula. Check the formula bar for a misspelling; if SEQUENCE is spelled correctly, your Excel version may not support it.
Which Excel versions support SEQUENCE?
SEQUENCE is available in Microsoft 365, Excel 2021 and later, and Excel for the web. Older Excel editions may return #NAME? because they do not include the function.
Can I create a sequence without upgrading Excel?
Yes. Enter =ROW(A1) in the first output cell, then drag its fill handle downward to create a numbered column.
Is #SPILL! the same as #NAME? for SEQUENCE?
No. #NAME? indicates that Excel does not recognize a name in the formula. #SPILL! means the formula's output cannot fill its intended range; check for cells or objects blocking that range.




