Get a load of Excel’s new multi-value cells
Excel's new in-cell data structures feature, currently in beta for Microsoft 365 Insiders, enables cells to hold multiple distinct values as lists or grids. Lists maintain sequences of typed values, arrays store grid data, and nested arrays allow complex outputs within individual cells. This capability simplifies formula processing and reduces worksheet clutter by eliminating the need to spill data across adjacent cells. General availability timing remains unannounced.
Key points
- Lists, arrays and nested arrays can now be stored within individual cells
- Each entry in a list preserves native data type (text, numbers, dates, Boolean)
- Currently available to Microsoft 365 Insider Beta Channel members on Windows and Mac
- Reduces need for spilling formulas across multiple rows and columns
Summary and key points written by AI from the headline and a short excerpt, so they can be incomplete or wrong. Computerworld did the reporting; read the original for the full story.
Read the full story at Computerworld
