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.

Excel running totals made easy with dynamic arrays. Explore advanced functions for accurate, flexible data handling and improved performance.

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.

However, expanding the hidden lines in the Excel spreadsheet is not as simple. To get the job done fast and avoid navigating through multiple menus, you can use a keyboard shortcut.

An curved arrow pointing right. {} These brackets mean something magical is happening inside your Excel formula. An "Array" function allows you to perform mathematical operations on many cells ...

On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a ...