Microsoft Excel now supports multiple values, Lists, nested arrays, and new array functions inside a single cell for Insider users.

Microsoft is changing a 40-year-old Excel rule by allowing a single cell to hold multiple values using new lists, arrays in cells, and nested arrays.

Currently in beta, Excel can now include entire lists within a single cell and still understand that they contain multiple values.

Select a cell and use Insert > List or press Ctrl+J to create a list.

Excel can feel like a maze of endless rows, columns, and formulas, especially when you’re trying to create something as detailed as a loan repayment report. If you’ve ever found yourself overwhelmed ...

Have you ever stared at a tangled web of Excel formulas, wondering if there’s a better way to make sense of it all? For many, Excel’s LAMBDA function feels like a cryptic puzzle—powerful but ...