Microsoft Excel Insiders Beta adds lists, arrays in cells, and nested arrays, plus HAS/HASANY/HASALL/FLATTEN, so related values can live in one cell without losing filtering and calculation.
Excel now supports multiple values in a single cell
Project trackers, surveys, inventory lists, and customer databases often contain related information that belongs together: multiple owners, tags, locations, or responses.
For years, organizing that information in Excel meant spreading it across additional rows and columns or combining everything into text that was difficult to work with.
Available today in Insiders Beta, lists, arrays in cells, and nested arrays introduce new ways to store and organize related information, helping you keep data together without sacrificing filtering, calculations, or analysis.
Let's explore these new functionalities in the context of a project tracker.
Start with lists
Each project may have multiple owners, workstreams, and milestones. Traditionally, you'd need separate columns, helper tables, or text like "Carlos, Henrietta, Jacob" packed into a single cell.
With lists, you can keep those values together in one cell while still working with each item individually. Project owners stay connected to the project they belong to, while remaining available for filtering, calculations, and analysis.
Take calculations further with arrays in cells
Keeping project owners together is just the beginning.
Projects often contain other groups of related information, such as milestone dates, deployment locations, or open risks. Often, that information is generated by formulas rather than entered manually.
Traditionally, formulas that returned multiple results would spill those results across multiple cells. With arrays in cells, those results can remain together in a single cell while still being available for calculations and analysis.
Handle more complex data with nested arrays
Sometimes the information associated with a project has structure of its own.
For example, a website launch may include separate design, development, and testing workstreams, each with its own set of milestones. Nested arrays help preserve those relationships, keeping milestone groups tied to the workstream they belong to rather than combining everything into a single list.
This creates a more natural way to organize and work with complex information in Excel.
New functions for working with arrays
We've also added new functions designed to help you search, validate, and reorganize this data.
Need a simple list of all milestones across every workstream? Use FLATTEN to consolidate nested results.
Want to find projects owned by a specific person? Use HAS .
Need to identify projects that involve any member of a leadership team? Use HASANY .
Want to find projects that include every required stakeholder before launch? Use HASALL .
Build more flexible spreadsheets
Together, these capabilities expand the kinds of information Excel can represent and work with, making it easier to model real-world data while keeping related information organized. Whether you're managing projects, analyzing survey responses, tracking certifications, or organizing product data, you can keep related information together without giving up the flexibility to filter, calculate, and analyze it.