Excel gets three updates: Center Across Selection, table names, and in-cell lists

Microsoft is gradually rolling out three Excel features: Center Across Selection in the Merge and Center menu, naming a table directly in the Create Table dialog, and lists and arrays inside a single cell. Four new functions — FLATTEN, HAS, HASANY and HASALL — support the new array structure.

• Center Across Selection added to the Merge and Center drop-down menu
• Table names can now be set in the Create Table dialog
• Lists and arrays live in one cell, with filters working on individual items
• New functions: FLATTEN, HAS, HASANY and HASALL