As an enhancement to Excel’s calculation engine, the Dynamic Arrays functionality enables a single formula to produce results that expand into other cells, as demonstrated in the SORT example below.

Select the array of cells that you want to collapse and expand. Click "Data" in the Excel ribbon. Click "Group" in the ribbon's Outline section to open a pop-up menu.

Microsoft has introduced two new automation features, called Formula suggestions and Formula by Example to the Microsoft 365 web version of Excel.