Excel Lets Cells Hold Lists

Updated: 2026.09.26 59MIN ago 1 sources
Microsoft is introducing native single‑cell lists and nested arrays in Excel, plus new functions (HAS/HASANY/HASALL, FLATTEN) and a way to 'wrap' spilled arrays to keep them inside one cell. The change converts ordinary cells into richer data containers and gives spreadsheet users structured, nestable data without leaving the worksheet. — This turns ubiquitous spreadsheets into lightweight databases and programmatic surfaces, shifting where complex logic and corporate data live and who can manipulate it — raising governance, auditing, and automation questions.

Sources

After 40 Years, Microsoft Excel Will Add Single-Cell Lists and Arrays
EditorDavid 2026.09.26 100% relevant
Microsoft's Excel product update: native in‑cell arrays and lists, braces to wrap arrays, and new HAS/FLATTEN functions as described by the Excel senior product manager and the feature docs linked in the article.
← Back to all ideas