Excel now supports multiple values in a single cell, introducing lists, arrays in cells, and nested arrays to help organize related information without sacrificing filtering, calculations, or analysis. Available today in Insiders Beta, these features allow users to keep data together while working with each item individually.

Users can create a list with Insert > List or Ctrl+J, then type or paste items separated by commas or semicolons. Selecting the icon in the cell shows the individual values. This allows for filtering by individual list items rather than whole text entries.

Arrays in cells let users keep the result of any spilling formula in a single cell by wrapping the formula body with braces { }. Nested arrays help preserve relationships in complex data, such as milestone groups tied to workstreams.

New functions like FLATTEN, HAS, HASANY, and HASALL help search, validate, and reorganize data. These capabilities make it easier to model real-world data while keeping related information organized.