📊Excel Now Allows Multiple Values in Single Cells
Excel just got a lot more flexible with multi-value cells
TL;DR
Microsoft's new Excel feature lets you stuff multiple values into one cell, making complex data easier to manage. But it might break your existing workflows.
Microsoft has introduced a new feature in Excel that allows multiple values to be stored in a single cell, a change that could revolutionize how complex data is handled in spreadsheets. This feature, called 'Lists, Arrays in Cells and Nested Arrays in Excel', is available in the Beta Channels for Windows and Mac and is opt-in. The feature enables users to keep related data together in one cell, making it easier to manage projects with multiple owners without the need for separate columns or helper tables. However, this flexibility comes with a catch: it may disrupt existing workflows and require updates to external software libraries and applications that import Excel data. The feature is currently in preview and should not be used in important workbooks until general availability.
Key Points
Microsoft's new Excel feature allows multiple values in single cells, available in Beta Channels for Windows and Mac.
The feature is called 'Lists, Arrays in Cells and Nested Arrays in Excel', enabling complex data management.
Each Excel project can now have multiple owners, with values kept together in one cell for easier filtering and analysis.
The feature may disrupt existing workflows and require updates to external software libraries and applications.
General availability of the feature is expected in Microsoft 365, but it's currently in preview and not recommended for critical workbooks.
Why It Matters
If you're managing complex projects in Excel, this feature could streamline your data management. However, it might break existing workflows and require updates to external software. For example, a project manager using Excel to track multiple owners for different projects can now keep all related data in one cell, improving visibility and ease of use. But developers integrating Excel data into their applications will need to update their code to handle multi-value cells.
Comments
Be the first to comment
Enjoyed this article?
Get it daily. 7am. Free. Reads in 5 minutes.
Join 3,508 builders reading daily.