For roughly 40 years, Microsoft Excel has operated around one basic rule: one cell, one value. Microsoft is now changing that.
Excel is introducing lists, arrays in cells, and nested arrays, allowing a single cell to contain multiple distinct values that Excel can still use for filtering and calculations. The new capabilities are rolling out first to Beta Channel users on Windows and Mac, according to Microsoft’s announcement.
It sounds like a small change to a spreadsheet. Under the hood, however, Microsoft is altering one of Excel’s most fundamental assumptions about how information is stored.
One Excel cell can now contain an actual list
Excel users have long put what appears to be multiple values into a single cell. A project tracker, for example, might have a cell containing several employee names separated by commas.
The problem is that Excel traditionally treats that content as a single text value rather than understanding each name as an independent item.
Microsoft’s new Lists feature changes that. Users can create a list by selecting Insert > List or pressing Ctrl+J, then entering or pasting items separated by commas or semicolons, depending on regional settings.
The values appear together visually in a single cell, but Excel recognizes them individually. Users can edit individual items and filter by one or more values in the list.
That could be particularly useful for spreadsheets tracking things such as:
- Multiple owners assigned to a project
- Product categories or tags
- Available meeting times
- Survey responses
- Locations associated with an account
- Skills assigned to employees
Instead of spreading that information across extra columns or storing it as an unwieldy text string, users can keep related data together while retaining Excel’s ability to work with the individual values.
For people looking to squeeze more out of Microsoft’s spreadsheet software, TechRepublic has also rounded up 10 clever Excel tricks to use in 2026.
Arrays no longer have to spill across multiple cells
Lists are only part of the change.
Microsoft is also allowing arrays to exist natively inside cells as values or formula results. The company says these arrays can have different sizes and shapes and can even contain other arrays.
That’s a notable departure from the behavior Excel users have become accustomed to with dynamic arrays.
Traditionally, when a dynamic array formula returns multiple results, Excel uses a “spill range,” placing those results into neighboring cells. TechRepublic’s guide to Excel spill ranges explains how that existing behavior works.
With arrays in cells, users can instead keep an array within a single cell by wrapping it inside another array.
For example, Microsoft says:
={1;2;3}
normally creates an array that spills three values into separate cells.
Adding another set of braces:
={{1;2;3}}
creates a 1-by-1 array containing the original array. That allows the three-value array itself to remain within a single cell rather than spilling into neighboring cells.
The distinction matters because spreadsheet designers no longer necessarily have to reserve adjacent cells for an array’s output. More complex data structures can potentially remain contained within the spreadsheet’s existing layout.
Microsoft previously made array formulas substantially easier to work with through dynamic arrays. Features such as Excel’s FILTER function already let a single formula generate multiple results across a spreadsheet. Arrays in cells take that concept in another direction by allowing the collection of values to occupy a single cell.
Excel is also getting nested arrays
Microsoft is going a step further by introducing nested arrays, which allow one array to contain other arrays.
Previously, Microsoft said formulas producing an array of arrays could return a truncated result or a #CALC! error. Supported formulas can now return the complete nested result.
Microsoft demonstrated the change with an array structured like this:
={{1,2,3};{4,5,6}}
Nested arrays could make it easier to preserve more complex relationships in the data without first flattening everything into a conventional grid.
Microsoft is also introducing functions designed to work with the new structures, including FLATTEN, HAS, HASANY, and HASALL.
FLATTEN converts nested arrays into a single array, while the HAS functions can determine whether arrays contain specified values.
However, an important compatibility consideration exists. Microsoft says most calculations involving nested arrays require Compatibility Version 3, a setting applied at the workbook level.
Microsoft warns that switching an existing workbook to Version 3 can cause some formulas to produce different results. Workbooks affected by those differences can remain on Compatibility Version 1 or 2, making this another area users should test before incorporating nested arrays into established workflows.
The change builds on years of Microsoft expanding what Excel can handle beyond traditional rows of numbers and formulas. The company has previously added features ranging from dynamic arrays to Python support inside Excel, increasingly blurring the line between a conventional spreadsheet and a more sophisticated data-analysis environment.
There are still some major limitations
The new data structures don’t work everywhere in Excel yet.
Microsoft lists several limitations in the current preview. Among them:
- PivotTables can’t read array values as source data.
- Power Query can’t load or output columns containing array values.
- Charts don’t expand array values into individual data points.
- Data validation can’t use array values as dropdown items.
- Find & Replace can’t replace individual items within lists or arrays.
Those restrictions are particularly important for anyone considering the feature for complex business spreadsheets. A workbook that relies heavily on PivotTables, Power Query, charts, or data validation may not yet be able to take full advantage of the new structures.
Microsoft could address some of these limitations as development continues, but the company hasn’t committed to when or whether each unsupported scenario will be added.
You probably shouldn’t rebuild your spreadsheets yet
There is another important catch: these features are still previews.
Microsoft specifically says it does not recommend using them in important workbooks until they are generally available, because their behavior could change based on feedback.
The features are initially rolling out to Beta Channel users running:
- Windows: Version 2610, Build 20520.20000 or later
- Mac: Version 16.114, Build 26092111 or later
Microsoft also cautions that Beta features roll out gradually, so having a qualifying version does not guarantee that lists and arrays in cells will appear immediately.
The company could pause, modify, or remove preview functionality before a wider release. Microsoft has not announced a general-availability date.
What Excel’s 40-year change means for you
For most Excel users, the immediate takeaway isn’t that existing spreadsheets suddenly need to be redesigned. Between the preview status, compatibility considerations, and current limitations, the feature isn’t ready for that yet.
What’s more interesting is what happens if Microsoft brings it to general availability largely as envisioned.
A cell no longer has to represent one isolated piece of information. It can represent a collection of related values while still allowing Excel to work with the individual items. That could make project trackers, surveys, inventories, schedules, and other everyday spreadsheets cleaner without forcing users to scatter related information across extra rows and columns.
Arrays in cells could also solve a familiar problem for more advanced users: formulas that need room to spill. Keeping an array inside a single cell could make complex models more compact and give spreadsheet designers greater control over their layouts.
There will also be a learning curve. Existing Excel habits, formulas, workflows, and integrations have spent decades operating around the assumption that one cell holds one value. The current limitations involving tools such as PivotTables and Power Query show why compatibility may matter just as much as the new functionality.
For now, this is a feature to experiment with rather than build critical work around. But if Microsoft ultimately makes lists and arrays in cells broadly available, one of Excel’s oldest assumptions will have quietly disappeared, potentially changing how people build spreadsheets after four decades of working within the same basic grid.
Additional reading: Looking beyond Microsoft’s spreadsheet? TechRepublic compared the 11 best free Excel alternatives for 2026, including Google Sheets, Zoho Sheet, and LibreOffice Calc.