Excel now supports multiple values in a single cell
Microsoft Excel is breaking its 40-year single-value-per-cell limit by introducing native support for lists, arrays in cells, and nested arrays in the Beta channel.
summary is enough The announcement details a fundamental architecture change to Excel, but the core mechanics are easily grasped from a summary.
summary
Microsoft Excel is dropping its 40-year-old single-value-per-cell constraint by introducing native lists, in-cell arrays, and nested arrays for Beta channel users. Formulas can now be wrapped in braces to keep spilling results inside a single cell, accompanied by four new helper functions like FLATTEN and HAS. While this simplifies complex enterprise models and intermediate helper ranges, early limitations prevent features like PivotTables and charts from reading array values.
key points
- Excel now allows multiple values, lists, and native arrays inside a single cell by wrapping formulas or data in braces.
- Four new functions, FLATTEN, HAS, HASANY, and HASALL, have been introduced to manage and query nested array structures.
- Current beta limitations restrict array values from interacting with PivotTables, Power Query, charts, and data validation.
who should read it
Excel power users, enterprise data analysts, and spreadsheet developers.
discussion positive
consensus
Commenters agree this represents a massive architectural shift that will clean up messy intermediate helper ranges in large enterprise models.
pushback
Some express concern that adding complex nested types compromises Excel's simplicity and intuitive mental model for casual users.
Technically, this is a huge deal for Excel because it represents a fundamental change from the traditional one-value-per-cell model. From a practical usage perspective, though, it may not be as revolutionary as it initially sounds.
I was playing around with it this morning and tested it on a fairly large Excel model with lots of spillable dynamic arrays used as intermediate calculations. I was able to replace those spill ranges with arrays in cells, and all the formulas referencing those results continued to work nicely. In many cases, enabling it was as simple as adding {} around the …
It shares practical testing experience showing how in-cell arrays instantly eliminate messy helper spill ranges in large models.
Generated by an LLM from the article and thread. Check the sources before relying on it.