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 b … ⌘ Read more