Microsoft tests Excel feature allowing multiple values per cell
Microsoft is piloting an Excel update that lets a single cell hold lists and arrays instead of just one value, breaking from the spreadsheet's traditional one-cell, one-value design. The feature is available to Microsoft 365 Insiders in the Excel Beta Channel on Windows and Mac, letting users create lists via Insert > List or Ctrl+J, and reference or filter individual items within them using formulas.
GoKawiil's interpretation of the reporting above, not reported fact.
Allowing grouped, editable data within a single cell could reduce reliance on helper columns and tables for tracking things like project owners or variable-length records, according to Excel's senior product manager Jake Armstrong. Because the feature is still in beta and opt-in, its eventual rollout and impact on existing spreadsheet workflows remain uncertain.
- Excel Beta Channel now supports lists and arrays within a single cell.
- Users can create lists via Insert > List or Ctrl+J, separating items with commas or semicolons.
- Formulas can reference individual list items or keep array outputs contained in one cell using braces.
Microsoft 365 Family Subscription — If you're eager to try Excel's new multi-value cell features like lists and nested arrays, a Microsoft 365 subscription keeps you on the latest Insider-ready builds across Windows and Mac. It's the easiest way to get continuous updates to Excel, Word, and other Office apps as these new spreadsheet capabilities roll out. Great for households or power users who want up-to-date productivity tools without buying software outright.”,
See Microsoft 365 Family Subscription on Amazon → Affiliate link — we may earn a commission on purchases, at no extra cost to you. Product picked by AI based on this article; it is not a tested recommendation.Source: techspot.com — Skye Jacobs, 2026-09-28
Published there as: “After 40 years, Excel is breaking one of its oldest rules: one cell, one value”
Read the original report → The summary and analysis above are GoKawiil's own, written from reporting by the source above. Facts and quotes belong to the original publisher.