Microsoft rethinks Excel after four decades: single cells can now hold multiple values

After 40 years of operation, Microsoft is fundamentally changing how Excel handles data at the cell level. The company has announced the introduction of lists and arrays in cells, allowing users to store multiple values within a single cell for the first time since the spreadsheet application's inception. The feature, now rolling out to Windows and Mac beta channels, addresses long-standing workflow challenges where users previously resorted to comma-separated text to track multiple data points in one location.

The update introduces native arrays that can exist as cell values or formula results, with sizes and shapes that can even contain nested arrays. Users can prevent array results from spilling across multiple cells by wrapping formula bodies with braces, effectively containing multi-value outputs in a single cell. To support these capabilities, Microsoft added four new functions, FLATTEN, HAS, HASANY, and HASALL, that help manipulate and query array contents. However, compatibility gaps remain: conditional formatting, pivot tables, charts, Power Query, and find-and-replace tools currently cannot fully interact with array-valued cells, signaling that the integration is still in early stages.

Available starting with Windows Version 2610 and Mac Version 16.114, the features remain in preview mode with Microsoft cautioning users against relying on them for critical workbooks until general availability. The company noted that behaviors may change based on feedback collected during the beta period, and some features could be paused, adjusted, or removed. While the announcement represents one of Excel's most significant architectural shifts in its history, widespread adoption will likely depend on how Microsoft resolves current limitations with existing spreadsheet ecosystem tools.