Microsoft cells out, crams multiple values into Excel boxes

Live updates

1. 1d ago

   Excel multi-value cells remain an Insider preview with no new release details

   Microsoft's preview of Excel cells containing multiple structured values remains unchanged. The feature, which uses nested arrays, is available to Microsoft 365 Insider members on the Beta Channel for Windows and Mac. Microsoft has not announced a general release date, and the preview does not support perpetual license versions or Excel for the web. The newly supplied material offers no direct confirmation of the feature's status, rollout plans or production readiness.

   Why it matters

   Multiple values in one cell could reduce worksheet clutter and simplify formulas that need to process grouped results. Existing Excel methods for combining or returning multiple values include FILTER, INDEX, TEXTJOIN, Power Query, custom VBA macros, UNIQUE and TOCOL. The new sources do not establish whether Microsoft's nested-array approach changes those methods or when users outside the Insider program will receive it.

   What to watch next

   • A Microsoft announcement specifying a general release date for multi-value cells
   • Microsoft documentation confirming support for Excel for the web and perpetual license versions
   • Evidence of expanded Insider testing beyond the Beta Channel for Windows and Mac
   Sources used for this update (6)

   1. www.gearpatrol.com — Gear Patrol | Product Reviews, Buying Guides and How-To’s
   2. excelinsider.com — How to Return Multiple Values Based on Single Criteria in Excel
   3. learn.microsoft.com — Windows appears to be recieving repeated keyboard shortcuts ...
   4. casrai.org — Multiple Regression in Excel: ToolPak and LINEST — CASRAI
   5. www.wps.com — How to Combine Unique Values from Multiple Excel Cells into ...
   6. support.fabric.microsoft.com — Microsoft Fabric Known Issues
   confidence 35%
2. 6d ago

   Microsoft Excel Previews In-Cell Arrays

   Microsoft is previewing a feature in Excel that allows users to store multiple distinct, structured values within a single cell. Previously, every spreadsheet cell was restricted to a single scalar value. The update introduces nested arrays that can simplify complex formula processing and reduce visual clutter on worksheets. These multi-value containers are currently available to members of the Microsoft 365 Insider program on the Beta Channel for Windows and Mac. Microsoft has not announced a general release date for all subscribers, and the feature is not supported in perpetual license versions or Excel for the web.

   Why it matters

   Traditional spreadsheet architecture dictates that a single worksheet cell holds only one scalar value. Although dynamic array formulas could spill values across adjacent rows and columns, the container itself remained singular. Allowing multiple values inside a single cell alters standard calculation and filtering workflows by letting users manage arrays directly within a cell boundary.

   What is confirmed

   • Microsoft is previewing a feature in Excel that lets users store multiple distinct, structured values within a single cell.
   • The new in-cell data structures are available in Excel for Windows and Mac to members of the Microsoft 365 Insider program on the Beta Channel.
   • Charts and PivotTables cannot yet work with the contents of these in-cell arrays.
   • The features are not supported in perpetual license versions such as Office 2021 or Office 2024, nor in Excel for the web.

   What to watch next

   • Microsoft announces a general rollout date for all M365 subscribers.
   • Support for charts and PivotTables interacting with in-cell array contents.
   • Availability expanding to perpetual license versions or Excel for the web.
   Sources used for this update (7)

   1. learn.microsoft.com — Excel actions reference - Power Automate | Microsoft Learn
   2. trumpexcel.com — Paste into Filtered Cells in Excel (Skip Hidden Rows)
   3. www.computerworld.com — Excel’s new multi-value cells: Use cases and how to use them ...
   4. technorapper.com — Get a load of Excel’s new multi-value cells - All About The ...
   5. visualizing.jp — One Cell, a Whole Array: Excel Lists and Arrays in Cells
   6. learn.microsoft.com — Application.Run method (Excel) | Microsoft Learn
   7. learn.microsoft.com — Microsoft Excell spreadsheets - Microsoft Q&A
   confidence 100%
3. 11d ago

   Microsoft Updates Excel to Support Nested Arrays

   Microsoft has introduced a nested arrays feature in Excel, allowing users to store lists and two-dimensional arrays inside a single cell. This update breaks a long-standing spreadsheet convention by letting Windows and Mac Beta Channel users generate lists using the Insert menu or the Ctrl+J shortcut. To manage these multi-value cells, Microsoft added new functions including HAS, FLATTEN, and VSTACK. These functions enable users to handle array cells, perform lookups, combine ranges, and build sorted, unique lists that alter traditional calculation and filtering workflows.

   Why it matters

   For decades, spreadsheet standards restricted cells to holding a single value. This restriction shaped how users structured data tables, built formulas, and moved information across sheets. Allowing multiple values inside a single box requires significant changes to how the platform handles calculations and data movement. Excel-University notes that users can now apply VLOOKUP directly on array cells, opening new methods for data analysis.

   What is confirmed

   • Microsoft updated Excel to allow multiple values within a single cell for Windows and Mac Beta Channel users.
   • Users can generate lists inside cells using the Insert menu or the Ctrl+J keyboard shortcut.
   • New functions like HAS and FLATTEN are designed to handle multi-value cells.
   • Functions like VSTACK allow users to combine ranges into one list, stack data from separate sheets, handle padding, and build sorted and unique lists.
   • The nested arrays feature allows users to store lists and two-dimensional arrays in a single cell and perform operations like VLOOKUP on array cells.

   What to watch next

   • Broad rollout of the nested arrays feature from Beta Channel to general availability for all Excel users
   • Further updates regarding how multi-value cells impact data filtering and external tool compatibility
   Sources used for this update (13)

   1. techcommunity.microsoft.com — Microsoft 365 Insider Blog | Microsoft Community Hub
   2. www.excelinsider.com — How to Consolidate Data in Excel from Multiple Columns
   3. visguy.com — insert user defined field - Visio Guy
   4. visguy.com — Pasted Excel Object doesn't display all info - Visio Guy
   5. www.excelshed.com.au — What? Multiple values in a cell? - excelshed.com.au
   6. excelinsider.com — How to Add Text to Multiple Cells in Excel (8 Different Ways)
   7. visguy.com — Import text as separate text fields - visguy.com
   8. trumpexcel.com — 24 Excel Tricks You Wish You Knew Yesterday - Trump Excel
   9. learn.microsoft.com — Excel cells appear on printout, not visible on the worksheet
   10. www.excel-university.com — Excel Nested Arrays: Multiple Values in One Cell
   11. excelinsider.com — How to Find Multiple Values in Excel (6 Effective Methods)
   12. learn.microsoft.com — Excel Spreadsheet Error Message - Microsoft Q&A
   confidence 100%
4. 23d ago

   Microsoft Excel Updates Standard With Multi-Value Cells

   Microsoft has updated Excel for Windows and Mac Beta Channel users to allow multiple values within a single cell, breaking a 40-year convention. Users can generate lists via the Insert menu or the Ctrl+J shortcut, while new HAS and FLATTEN functions handle the multi-value cells. These adjustments alter data movement, calculations, and filtering across the platform. Related functions such as VSTACK allow users to combine ranges into one list, stack data from separate sheets, handle padding, and build sorted, unique lists.

   Why it matters

   Excel updates alter foundational data management rules by permitting multiple values inside individual cells. Users must adapt traditional calculation methods as the software handles data movement and filtering differently. Supplementary functions assist with combining ranges and stacking data from separate sheets.

   What is confirmed

   • Microsoft updated Excel for Windows and Mac Beta Channel users to allow multiple values within a single cell.
   • Users can generate lists using the Insert menu or the Ctrl+J shortcut.
   • The update introduces the HAS and FLATTEN functions to manage multi-value cells.
   • The VSTACK function can combine ranges into one list, stack data from separate sheets, handle #N/A padding, and build sorted, unique lists.

   Still unconfirmed

   • A user reported that the Sum formula incorrectly outputs a zero when calculating a vertical range of cells like =SUM(A3:A5).

   What to watch next

   • Broader rollout of multi-value cell capabilities beyond Beta Channel users
   • Official Microsoft patches addressing potential calculation errors with vertical ranges in the SUM formula
   Sources used for this update (3)

   1. trumpexcel.com — VSTACK Function in Excel (7 Examples)
   2. learn.microsoft.com — The Sum formula will not add a vertical range of cells ...
   3. www.howtogeek.com — 7 Excel features I overlooked that solve problems I used to ...
   confidence 100%
5. 26d ago

   Microsoft Excel Beta introduces multi-value cells

   Microsoft updated Excel for Windows and Mac Beta Channel users to allow multiple values within a single cell, ending a 40-year standard. Users can now generate lists using the Insert menu or the Ctrl+J shortcut. The update introduces the HAS and FLATTEN functions to manage these multi-value cells. These changes fundamentally alter how the software handles data movement, calculations, and filtering.

   Why it matters

   Excel traditionally restricted one piece of data per cell to maintain database integrity. This shift allows for more flexible data entry and complex list management within a single coordinate.

   What is confirmed

   • Excel for Windows and Mac Beta Channel users can now put multiple values in one cell.
   • The update includes new HAS and FLATTEN functions.
   • Users can create lists via the Insert menu or by pressing Ctrl+J.

   Still unconfirmed

   • The KB5002934 security update released October 13, 2026, caused copy-and-paste issues in Excel 2016 64-bit.

   What to watch next

   • General availability of multi-value cells for non-Beta users
   • Microsoft response to reported copy-paste issues in Excel 2016
   Sources used for this update (4)

   1. www.howtogeek.com — I tested the 9 most popular Linux desktop environments, here’s how I’d rank them - How-To Geek ,We Explain Technology
   2. techcommunity.microsoft.com — Excel Blog | Microsoft Community Hub
   3. learn.microsoft.com — Excel 2016 Copy/Paste Issue After KB5002934 Update ...
   4. www.exceldemy.com — ExcelDemy - Learn Excel & Get Excel Solutions
   confidence 100%
6. 29d ago

   Microsoft Excel allows multiple values in cells

   Microsoft has updated Excel to enable multiple values in a single cell, a change from the 40-year standard. This update is available to Windows and Mac Beta Channel users and introduces new functions like HAS and FLATTEN. Users can create lists via the Insert menu or by pressing Ctrl+J. The update changes how users filter, calculate, and move data.

   Why it matters

   This change may require updates to third-party software reading .xlsx files. The update aims to improve data management and flexibility in Excel. Microsoft's update is currently available to Beta Channel users, indicating a wider release may follow. The change affects core Excel functionalities.

   What is confirmed

   • Microsoft's update allowing multiple values in Excel cells is now available to Windows and Mac Beta Channel users.
   • The update introduces new functions like HAS and FLATTEN.
   • Users can create lists via the Insert menu or by pressing Ctrl+J.

   What to watch next

   • Wider release of the update to non-Beta Channel users
   • Updates from third-party software developers on .xlsx file compatibility
   • Feedback from users on the new functionality and its impact on workflows
   Sources used for this update (2)

   1. www.microsoft.com — Download Drivers & Updates for Microsoft, Windows and more -...
   2. www.howtogeek.com — 3 Excel updates you won't want to miss (and none of them involves Copilot) - How-To Geek ,We Explain Tech....
   confidence 100%
7. 36d ago

   Microsoft's multi-value Excel cells roll out, stir compatibility concerns

   Microsoft's update allowing multiple values in Excel cells is now available to Windows and Mac Beta Channel users, introducing new functions like HAS and FLATTEN. This change, ending a 40-year standard, may require updates to third-party software reading .xlsx files. Users can create lists via the Insert menu or by pressing Ctrl+J. The update changes how users filter, calculate, and move data.

   Why it matters

   The update aims to enhance Excel's functionality, particularly in handling complex data sets. It has sparked discussions in the Microsoft Community Hub and raised concerns about compatibility with existing workflows and third-party software. Users are exploring how to adapt to the changes and troubleshoot issues like the #SPILL! error.

   What is confirmed

   • The #SPILL! error in Excel can be caused by cells in the way, hidden spaces, whole columns, tables, and merged cells.
   • Microsoft is updating Excel to allow individual cells to store lists, arrays, and nested arrays.
   • The update introduces new functions like HAS and FLATTEN.
   • Users can create lists in Excel via the Insert menu or by pressing Ctrl+J.

   Still unconfirmed

   • Compatibility issues with third-party software reading .xlsx files are being monitored.

   What to watch next

   • Microsoft's official release of the update for all Excel users
   • Feedback from users on the Microsoft Community Hub regarding the update's impact
   • Resolution of compatibility issues with third-party software
   Sources used for this update (6)

   1. coddy.tech — #SPILL! Error in Excel: Causes and Fixes - Coddy
   2. techcommunity.microsoft.com — Tag:"excel" | Microsoft Community Hub
   3. bettersolutions.com — Excel Formulas - Omits Adjacent Cells - BetterSolutions.com
   4. nbkomputer.com — Excel And Datatable Activities In Power Automate Desktop A ...
   5. masterexcelfunctions.com — Why Your IF Formula Returns the Wrong Result: 6 Causes and Fixes
   6. laptopjudge.com — Excel Autocomplete (Suggestion Repair) - LaptopJudge
   confidence 90%
8. 38d ago

   Microsoft tests multi-value cells in Excel Beta

   Microsoft is testing a change to Excel that allows individual cells to store lists, arrays, and nested arrays. This update ends a 40-year standard where each cell held only one value. Currently available to Windows and Mac Beta Channel users, the feature introduces new functions like HAS and FLATTEN. Users can create lists via the Insert menu or by pressing Ctrl+J. The update changes how users filter, calculate, and move data, though it may require updates to third-party software that reads .xlsx files.

   Why it matters

   The single-value rule was one of the oldest constraints in spreadsheet software. This shift allows for more complex data storage within a single grid coordinate. It represents a fundamental change in how data logic and validation are handled in Excel.

   What is confirmed

   • Excel cells can now hold lists, arrays, and nested arrays.
   • The feature is available through the Windows and Mac Beta Channels.
   • Jake Armstrong, senior product manager for Excel, stated that the rule of one cell, one value is "No longer!"
   • The update ends 40 years of single-occupancy for Excel cells.

   Still unconfirmed

   • Users should not share these workbooks yet.
   • The update may require updates across software that reads .xlsx files.

   What to watch next

   • General availability release date for non-beta users.
   • Confirmation of compatibility issues with third-party .xlsx libraries.
   • Documentation on the specific logic for the HAS and FLATTEN functions.
   Sources used for this update (18)

   1. account.microsoft.com — Microsoft account | Sign In or Create Your Account Today ...
   2. en.wikipedia.org — Microsoft - Wikipedia
   3. www.howtogeek.com — Someone else's Excel spreadsheet, my problem now—these 5 tools help me handle it - How-To Geek ,We Expl....
   4. aisignal.kr — 마이크로소프트 — 최근 동향·주요 뉴스 정리 (9월 29일 기준) | AIsignal 아카이브
   5. news.lavx.hu — Microsoft cells out, crams multiple values into Excel boxes
   6. forums.theregister.com — Microsoft cells out, crams multiple values into Excel boxes
   7. londontribune.co.uk — Microsoft cells out, crams multiple values into Excel boxes
   8. biztoc.com — Microsoft cells out, crams multiple values into Excel boxes
   9. leansupplai.com — Microsoft cells out, crams multiple values into Excel boxes
   10. www.microsoft.com — Experience the Windows difference with Windows 11 OS, Laptops,...
   11. apps.microsoft.com — Microsoft Store - Download apps, games & more for your Windows PC
   12. support.microsoft.com — Sign in to Microsoft 365
   confidence 90%
9. 45d ago

   Microsoft Excel Beta Introduces Support for Multiple Values in Single Cells

   Microsoft Excel is rolling out a new beta feature that allows single spreadsheet cells to store multiple values and nested arrays. This update changes how users format and manage data within grids by enabling a single cell to hold more than a single data point. Microsoft has published details explaining how the new functionality operates within the application. The change addresses long-standing limitations regarding data storage inside individual spreadsheet cells. Users participating in the beta channel can now test the capability.

   Why it matters

   Spreadsheet software traditionally restricts individual cells to a single data point, forcing complex workarounds for multiple entries. The introduction of nested arrays and multi-value storage in Excel represents a shift in data management for heavy spreadsheet users. Microsoft is currently detailing the mechanics of the update for those testing the beta software.

   What is confirmed

   • Microsoft Excel beta lets single cells store nested arrays and multiple values.

   What to watch next

   • General availability rollout timeline for non-beta users
   • User feedback on performance and stability of nested arrays
   Sources used for this update (5)

   1. The Register — Microsoft cells out, crams multiple values into Excel boxes
   2. Digital Trends — Microsoft Excel can now put multiple values in a single cell
   3. geeky-gadgets.com — Microsoft Excel Beta Lets Single Cells Store Nested Arrays
   4. Neowin — Excel finally supporting multiple values in single cell, Microsoft explains how
   5. Windows Report — Microsoft Excel Can Now Store Multiple Values in One Cell
   confidence 100%