After 40 years, Excel is breaking one of its oldest rules: one cell, one value
Serving tech enthusiasts for over 25 years. TechSpot means tech analysis and advice you can trust.
First look: Microsoft is testing a version of Excel that allows users to put more than one value inside a cell, a break from the spreadsheet program's longstanding one-cell, one-value model. The new capability includes lists, arrays in cells and nested arrays. It is available on an opt-in basis to Microsoft 365 Insiders in the Excel Beta Channel for Windows and Mac.
Lists are the most straightforward part of the rollout. A user can create one through Insert > List or by pressing Ctrl+J, then add items separated by commas or semicolons, based on regional settings. The values remain grouped in one cell, but Excel can treat them as separate items rather than one string of text.
That could help with spreadsheets that track projects, people or other records with a varying...
Copyright of this story solely belongs to www.techspot.com. To see the full text click HERE
