Excel lets you put a list of values in one cell now

After 40 years of one value per cell, Excel now lets you put multiple values inside a single cell. The feature, called lists and arrays, is rolling out to Microsoft Excel for Windows and Mac Beta Channels.

Lists and the One-Cell Filter

You create a list by selecting Insert > List or pressing Ctrl+J, then typing items separated by commas or semicolons. The cell shows the whole list, but clicking the icon inside it reveals each value individually. You can add, remove or edit items by double-clicking or pressing F2.

This matters because many workbooks already pack multiple values into one cell anyway. A project might list “Carlos, Henrietta, Jacob” as owners. A survey might return “2:00 PM; 2:30 PM; 3:00 PM” as a single response. Now those lists can stay in one cell while still filtering on individual items.

Arrays That Stay Put

For the first time in Excel, arrays can exist natively inside cells as values or formula results. You wrap any spilling formula in braces { } to keep it in a single cell rather than letting it spill across adjacent cells. The braces turn a spilled array into a 1×1 array around the original result.

The new arrays can be any size or shape, and they can contain other arrays inside them. A nested array example is ={{1,2,3};{4,5,6}}. Previously, formulas that produced arrays of arrays would return a truncated result or #CALC! error. Now they return the full nested result.

Four Functions to Manage the Mess

Four new functions help you work with nested arrays:

• FLATTEN(array, [pad_value], [levels]) removes one or more levels of nesting. In the example given, FLATTEN spills the individual results into the grid, using an empty string (“”) for pad_value so rows with fewer items show blanks in the remaining columns.
• HAS(array, value) checks whether a value appears in an array and returns TRUE or FALSE.
• HASANY(array, values) checks whether any of several values appear in an array and returns TRUE or FALSE.
• HASALL(array, values) checks whether all of several values appear in an array and returns TRUE or FALSE.

Limits on the Way Up

Not everything works with arrays in cells yet. The release notes list several limitations, including:

When It Arrives

These features are rolling out to Beta Channel users on Windows (Version 2610, Build 20520.20000 or later) and Mac (Version 16.114, Build 26092111 or later). A new Compatibility Version 3 is required for most nested array calculations, though some existing formulas return different results in it.

The release notes are a preview. Microsoft says behavior may change before general release based on feedback, and it doesn’t recommend using these features in important workbooks until they’re generally available.

What We Make of It

This is a real upgrade to a 40-year-old tool. Lists and arrays in cells are not a cosmetic change — they let you build spreadsheets that were previously impossible without spilling formulas across whole grids. The four new functions and the nested array support make the feature more useful than a simple text wrapper.

The limitations are real, and the requirement to set Compatibility Version 3 on a per-workbook basis is a friction point for anyone managing shared files. But the promise is there: you can now keep a list or an array in one cell, filter by its items, and reference the whole thing in a formula.

The Beta rollout means this is still a preview. The features may change, pause, or even disappear as Microsoft monitors quality and performance. But the direction is clear: Excel is finally moving past one value per cell.

Source material: “Excel now supports multiple values in a single cell,” microsoft.com.

arrays · beta · Excel · Microsoft · spreadsheet