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.

You can create outlines that group sections like these so that readers can expand or collapse them as needed. How to Make All Excel Rows the Same Height. Microsoft Excel spreadsheets help you make ...

Microsoft has announced it’s making Excel’s autocomplete even smarter, at least in the web version that comes with Microsoft 365 (formerly known as Office 365). Last week it announced formula ...