Excel Breaks a 40-Year Rule: Microsoft Lets One Cell Hold Multiple Values
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. The post Excel Breaks a 40-Year Rule: Microsoft Lets One Cell Hold Multiple Values appeared first on TechRepublic .
Microsoft is altering a longstanding Excel rule that has existed for over 40 years. The software giant is now allowing a single cell to contain multiple values using new lists, arrays, and nested arrays. This change enables Excel to recognize individual items within a list and filter them, as well as store arrays within cells. This development benefits users who want to keep related data together within a spreadsheet while maintaining Excel's ability to work with individual values.
The feature is currently in preview for Windows and Mac Beta Channel users, and Microsoft warns that it may change based on user feedback.
Written by urgent.news from TechRepublic's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
