Microsoft Excel Previews 3 Multi-Value Cell Types for Windows and Mac
Updated
Updated · Computerworld · Nov 4
Microsoft Excel Previews 3 Multi-Value Cell Types for Windows and Mac
3 articles · Updated · Computerworld · Nov 4
Summary
Excel’s preview feature lets a single cell hold structured lists, arrays and nested arrays, breaking its long-standing one-value-per-cell model.
Those in-cell structures are designed to cut worksheet clutter and avoid #SPILL! conflicts by keeping multi-item or formula-generated outputs inside one cell instead of spreading across adjacent cells.
Microsoft says the feature is available only to Microsoft 365 Insider users on the Beta Channel for Windows and Mac; Excel for the web and perpetual-license editions such as Office 2021 and 2024 are excluded.
4 new functions — FLATTEN, HAS, HASANY and HASALL — support the feature, but Microsoft warns of higher memory use, slower calculations and formula errors in unsupported versions.
General release timing is still undisclosed, and Microsoft says behavior may change based on Insider feedback before broader rollout.
Microsoft is breaking Excel's oldest rule by allowing multiple values per cell, but what hidden performance costs come with this massive update?
With PivotTables and Power Query currently unsupported, can Excel's radical new nested arrays truly replace traditional databases for complex workflows?
Will packing multiple values into a single Excel cell revolutionize data management, or just create an unreadable, memory-hogging nightmare for users?