For four decades, the fundamental law of spreadsheet software has remained entirely unchanged: one cell could hold only one value. Whether that value was a single number, a short date, a boolean flag, or a text string, the underlying grid architecture treated every individual cell as an atomic unit of data. According to recent reports, Microsoft is now actively testing a groundbreaking update to Excel that shatters this foundational constraint.
This new capability introduces lists, arrays stored directly inside individual cells, and advanced nested arrays. Currently rolling out on an opt-in basis to Microsoft 365 Insiders in the Excel Beta Channel for Windows and Mac, the change marks one of the most radical architectural evolutions in spreadsheet history. Users can finally group multiple related data points together while maintaining full computational access to each individual item.
Understanding In-Cell Lists and Arrays
The most immediate application of this new feature is the introduction of native lists. Users can quickly create a list within a single cell through Insert and then List, or by simply pressing Ctrl+J, and then typing items separated by commas or semicolons based on regional settings.
The values remain neatly grouped inside one cell, yet Excel treats them as distinct, separate items rather than a simple block of text. In traditional spreadsheet workflows, tracking variable entries like project owners, inventory locations, or attendee lists required messy comma-separated text strings, rigid auxiliary columns, or complex helper tables.
With this new update, a single project row can cleanly house a complete list of team members. Users can open the list interface directly from the cell icon, or edit the contents by double-clicking the cell or pressing F2. Furthermore, Excel can dynamically reference these lists in formulas and filter operations, even spilling items into separate adjacent cells when needed.
The Power of In-Cell Arrays and Nested Structures
Beyond basic lists, the update brings profound changes to how Excel handles arrays. Users can now store an entire array inside a single cell, whether entered manually as a value or generated dynamically via a formula.
These arrays can feature varying dimensions and may even contain other arrays within themselves. Conventionally, dynamic array formulas like braces containing a series of numbers would automatically spill their outputs across multiple worksheet cells. By wrapping the formula body with specific formatting braces, users can now keep complex outputs neatly contained within a single structured cell.
Nested arrays take this capability a step further by allowing formulas to return multi-layered array results without triggering calculation errors. Microsoft demonstrated this capability using a running log example, where each row represents a separate running session containing an array of split times. Sessions with entirely different numbers of individual splits can now safely coexist within the same table, while Excel effortlessly calculates overall metrics like total duration, average split time, and fastest pace.
To support these complex data structures, Microsoft is introducing four dedicated worksheet functions. The FLATTEN function removes layers of nesting from an array, HAS checks whether an array contains a specific value, HASANY looks for any of several supplied values, and HASALL verifies if all requested values are present within the structure.
Workflow Implications and Software Compatibility
While this update unlocks unprecedented flexibility for advanced spreadsheet modelers, it also introduces significant complexities. Countless external software applications, database connectors, and programming libraries that read Excel files are built on the historical assumption that a cell contains a standard string, number, date, or boolean.
Microsoft has not yet detailed how lists, in-cell arrays, and nested structures will be represented within standard XML file formats. This ambiguity means software developers and enterprise data teams will likely need to update their importing tools and data pipelines once the feature reaches general availability.
Additionally, several core Excel features do not yet support the new cell types. PivotTables cannot currently use array values as source data, Power Query cannot natively load or emit array-valued columns, and charts cannot automatically convert array entries into individual data points. Data validation rules cannot draw dropdown values from these new lists, and the standard Find and Replace tool cannot alter a single hidden item inside an array or list.
Most calculations involving complex nested arrays also require a new workbook configuration known as Compatibility Version 3. Because this setting can alter calculation outcomes in older formulas, Microsoft advises users to keep critical production workbooks on Compatibility Version 1 or 2 until the feature set matures and achieves general availability.
Key Takeaways
- Microsoft is testing an update to Excel that breaks the 40-year rule of restricting each cell to a single atomic value.
- New features include native in-cell lists, direct storage of single-cell arrays, and advanced nested multi-layered arrays.
- Four dedicated worksheet functions (FLATTEN, HAS, HASANY, and HASALL) are being introduced to support complex data structures.
- Compatibility limitations mean features like PivotTables, charts, and certain data validation rules do not yet fully support the new cell types.
- Workbooks utilizing complex nested arrays require Compatibility Version 3 settings.
Join our community by subscribing to our Weekly Newsletter to stay updated on the latest AI updates and technologies, including the tips and how-to guides.
Also, follow us on Instagram (@tid_technology) for more updates in your feed and our WhatsApp Channel to get daily news straight to your Messaging App.
