Excel Adds Single-Cell Lists and Arrays

Microsoft is adding lists and arrays inside single Excel cells, ending a 40-year limit of one value per cell. Users create a list via Insert > List or Ctrl+J, typing comma or semicolon separated items, then filter by individual items instead of whole text entries. Referencing a list returns all its values.