Search
Microsoft Tests Major New Feature for Excel: Storing Multiple Values in Cells with Simultaneous Addition of Lists and Nested Arrays
17 hour ago /
Read about 0 minute
Author：小编
Microsoft is testing a new Excel feature that allows cells to store multiple structured values simultaneously, including lists, cell arrays, and nested arrays. Users can create lists via 'Insert > List' or the shortcut Ctrl+J, separating items with commas or semicolons. The new feature supports filtering individual items within lists and introduces new functions such as HAS, HASANY, HASALL, and FLATTEN to enhance data processing flexibility and efficiency. The beta version has been rolled out to Microsoft 365 Beta users and will be available to general users in the future.
-
C114 Communication Network -
Communication Home
7 X 24 Track global technological trends
