Excel now supports multiple values in a single cell

Excel now lets cells hold multiple discrete values and structured groups so related information can stay together without breaking filters or formulas. Users can create lists in a cell (Insert > List or Ctrl+J) by typing or pasting comma- or semicolon-separated items; an icon reveals each item and filters operate on individual list members instead of the whole text string. This addresses common needs in project trackers, surveys, inventories, and customer records where fields like owners, tags, locations, or responses naturally contain multiple entries.

Beyond simple lists, formulas that return multiple results can be wrapped into a single cell as arrays by enclosing the formula body in braces, preserving spill results without dispersing them across the sheet. Nested arrays keep subgroups linked (for example, workstreams each with their own milestone lists), and functions tailored for these structures help search, validate, and reshape data: FLATTEN consolidates nested results, HAS checks membership, HASANY finds any matching members, and HASALL verifies all required members. These capabilities expand modeling of real-world, hierarchical data while retaining filtering, calculation, and analysis, and are available now in Insiders Beta.