Microsoft Excel Ends 40-Year Rule: Cells Now Support Multiple Values and Nested Arrays

Microsoft has introduced new features to Excel, allowing cells to hold multiple values and nested arrays for the first time in 40 years. The update includes four new functions—FLATTEN, HAS, HASANY, and HASALL—to manage these data structures. While these features enable more flexible data entry and calculation, Microsoft warns that they are currently in preview and have limitations regarding compatibility with existing tools like PivotTables, charts, and data validation. The update is being rolled out to Beta users on Windows and Mac.