After 40 Years, Microsoft Excel Will Add Single-Cell Lists and Arrays

Microsoft’s senior product manager for Excel acknowledges that “Throughout Excel’s 40-year history, you’ve only been able to put one value per cell.” But that’s now changing with arrays in cells (as well as nested arrays) and lists. “You can create a list by selecting Insert > List or pressing Ctrl+J, then typing or pasting items separated by commas or semicolons, depending on your regional settings. Selecting the icon in the cell shows the individual values…” “With lists, you can filter by one or more individual items instead of whole text entries.