Excel breaks its 40-year one-value-per-cell rule with lists and nested arrays

Microsoft is rolling out three related changes to Excel that let a single cell hold more than one value for the first time in the app’s history. The headline feature, Lists, lets users pack multiple entries—say, several project owners or survey time slots—into one cell (via Insert > List or Ctrl+J) while keeping each item individually filterable and usable in calculations. Underpinning it is a deeper shift: arrays can now exist natively inside cells rather than spilling across the grid. Wrapping a formula in braces keeps its result in a single 1x1 cell, and arrays can now nest inside other arrays, so functions like TEXTSPLIT return complete multi-row results instead of truncating or throwing #CALC! errors.

Four new functions support the model—FLATTEN to collapse nesting levels, and HAS/HASANY/HASALL to test membership within arrays. Nested-array math depends on a new Compatibility Version 3, set per workbook, which Microsoft warns can change the output of some existing formulas; workbooks can stay on version 1 or 2 if needed. The features are preview-only in the Windows and Mac Beta Channels (Windows build 2610/20520.20000 and Mac 16.114 or later), and Microsoft explicitly advises against using them in important workbooks until general availability.

The rollout carries real caveats for anyone building around it. Array contents are currently invisible to PivotTables, charts, data validation dropdowns, Power Query, and Find & Replace, and conditional formatting only sees them through formulas. That makes this a foundational reworking of Excel’s data model rather than a finished feature—powerful for flexible table designs like variable-length run trackers, but not yet wired into the surrounding ecosystem that most spreadsheets rely on.