Excel Breaks Its Own Rule: Storing Multiple Values in One Cell

Microsoft is testing a new version of Excel that breaks one of its oldest rules: allowing users to put more than one value inside a cell.

The change, available on an opt-in basis to Microsoft 365 Insiders in the Excel Beta Channel for Windows and Mac, includes lists, arrays in cells, and nested arrays.

Users can create lists through the 'Insert > List' option or by pressing Ctrl+J, then add items separated by commas or semicolons based on regional settings.

Excel can treat these values as separate items rather than one string of text, which could help with spreadsheets that track projects, people, or other records with a varying number of related entries.