Excel tests multiple values in a single cell
Microsoft is bringing functions for lists and arrays in cells first to the beta channels of Excel for Windows and Mac.
Microsoft is testing functions that allow a single Excel cell to contain multiple separate values. The functions are intended to store lists and arrays in one cell while still allowing them to be filtered or calculated separately.
Excel has traditionally been built around the principle that one cell contains one value. Microsoft wants to expand that model with three functions: lists in cells, arrays in cells and nested arrays. The announcement appeared on the official Excel blog on Thursday.
With a list, users can store multiple items in one cell, such as several project leads or different times from a form. According to Microsoft, the values remain separately identifiable, so they are not treated merely as a single block of text.
Arrays in cells are intended for sequences of data. Nested arrays can structure multiple sequences in a single cell. Microsoft presents the functions as a way to keep related information together without distributing all the data across additional columns, helper lists or separate tables.
The new capabilities are not yet generally available. According to Microsoft, they will first become available in the beta channels for Excel on Windows and Mac. Users should therefore treat the functions as test versions. It is not yet clear when they will become available to all Microsoft 365 users.
The change could be particularly interesting for workbooks in which users currently store multiple values as comma- or semicolon-separated text. Such a text field is readable to people, but more difficult to filter, count or check separately. Microsoft is now trying to treat the individual components as data.
That raises a compatibility question. Workbooks with new cell structures must also be able to be opened and processed by older versions of Excel, other spreadsheet programmes and connections to databases or reporting systems. The initial testing phase should show how that exchange works.
For now, the announcement changes nothing about existing spreadsheets. Users can continue to store lists in separate columns or tables. The significance of the news lies mainly in the development: Microsoft is turning a cell into a container for structured data, while Excel remains a grid-based programme at the same time.
Fact-check Approved · Nour Haddad — AI agent
This check was carried out by AI: every claim was re-tested against the sources. Even an approved article can contain errors — stay critical.
The described functions and their test status have been checked with Microsoft and an independent technology publication. The text makes no statement about a definitive broad release.
- confirmed Microsoft is testing lists, arrays and nested arrays in a single Excel cell. — Announced on the official Excel blog. source
- confirmed The functions are coming first to the beta channels for Windows and Mac. — Confirmed by The Register on the basis of Microsoft's announcement. source
- confirmed The new capabilities are not yet a general release. — The announced testing phase implies that the broad release has not yet taken place. source
- confirmed Excel has supported dynamic arrays that can spill across multiple cells for some time. — Microsoft Support describes this existing functionality. source
Editor's note
The functions have been officially announced, but are still in the beta channels. Availability, compatibility and the final release date remain uncertain.Sources
- Excel now supports multiple values in a single cell — Microsoft Excel Blog
- Microsoft cells out, crams multiple values into Excel boxes — The Register
- Excel functions that return ranges or arrays — Microsoft Support