Microsoft tests Excel's revolutionary support for multiple values and nested arrays in cells

Microsoft is trialling a major update to Excel, allowing cells to hold multiple distinct values and nested arrays, potentially transforming data handling, though the feature remains in experimental beta form.

Microsoft is testing a substantial change to one of Excel’s oldest assumptions: that a cell holds a single value. In preview builds, the spreadsheet can now store multiple distinct values inside one cell through new Lists and array support, a shift that may matter most to users handling structured or irregular data. According to reports from Windows Latest and Windows Report, the feature is available in the Excel Beta Channels for Windows and Mac, and Microsoft has cautioned that the behaviour may still change before wider release.

The most visible addition is Lists, which let users keep several items together without collapsing them into a single text string. Microsoft says a list can be inserted through the menu or with the Ctrl+J shortcut, after which values can be entered or pasted using commas or semicolons depending on regional settings. The items remain individually addressable, so users can filter, edit and reference them separately rather than treating the cell contents as one block of text. That could make spreadsheets easier to maintain where a single record needs to carry multiple related entries, such as several owners, time slots or categories.

Microsoft is also extending Excel’s formula model with arrays that can live directly inside cells, including nested arrays. According to coverage from Windows Latest and ContentBuffer, this is intended to handle cases where previous formulas could not fully represent array-of-array structures and would instead return a #CALC! error. Microsoft has added functions including FLATTEN, HAS, HASANY and HASALL to help users inspect and reshape these structures, while a demonstration showed a running tracker with different kilometre splits stored in the same row and analysed alongside the data.

The update remains experimental, and Microsoft is not yet treating it as production-ready. Coverage from multiple outlets says the new data types do not fully integrate with features such as conditional formatting, data validation, charts, PivotTables, Power Query and Find & Replace, and nested-array calculations require Compatibility Version 3. Some reports also note that the rollout is tied to specific beta builds, including Windows version 2610 and Mac version 16.114, which underlines that access is still limited to testers. For now, Microsoft is signalling that users should avoid relying on the feature in important workbooks until the preview stabilises.