Microsoft Excel is changing how data fits inside a single cell. The program has long allowed only one value per cell. Now, a preview feature lets users store multiple distinct, structured values within one cell.
New Data Structures for Cells
Three new data structures can be placed inside a cell. They help simplify complex formula processing and reduce clutter on the worksheet.
The feature is currently available for Excel on Windows and Mac. It is open to members of the Microsoft 365 Insider program on the Beta Channel. Microsoft has not announced a general release date for all M365 subscribers. These features are not supported in perpetual license versions like Office 2021 or in Excel for the web.
Practical Uses for Multi-Value Cells
One use is for categorizing items. Imagine listing co-workers who each know up to five software tools. Storing this information in one column per tool could take up many columns. With an in-cell list, all the information for one person can be in a single column. Excel recognizes each item in the list. Users can then filter for one or more items using the column’s drop-down arrow.
Another use is for survey responses. If respondents rate several questions on a scale, each response can be stored in one cell instead of a separate column for each question. This keeps the spreadsheet cleaner, especially if other columns store additional data about each person.
The new structures can also help with formula errors. When using functions like TEXTSPLIT across a column, standard dynamic arrays may try to spill output sideways. If there’s data in adjacent cells, this causes a #SPILL! error. An in-cell array can pack the split output inside each row’s cell. This avoids spilling into other cells and prevents formula collisions.
To create and edit these structures, users can use manual shortcuts or dynamic formulas. When a formula references a cell with a list, Excel spills the array into adjacent cells. To extract specific elements without spilling, functions like INDEX or field access operators can be used. This allows for more targeted data manipulation without disrupting the worksheet layout.
Because these features are in preview, Microsoft warns that their behavior could change based on feedback from M365 Insiders before a general release.
