What's New in Excel (August 2022)
Welcome to the August 2022 update. This month, we have many new features rolling out to Insiders and many more becoming generally available (GA) across web, Windows, and Mac. New functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are now GA; and the IMAGE function to insert images in cells is rolling out to the Beta channel for Insiders.
Excel for the web
Excel for Windows
Excel for Mac
Android
iOS
New Excel Functions
Power Query Group operations
Improvements to the connected Power BI experience
Add and edit rich text formatting
Rich text formatting allows the user to add formatting to only part of the text within a cell. You can use the ribbon or shortcuts to add the formatting.
Sort by color or icon from auto filter menu
Sorting is now easier and more convenient with new sort-by-color or icon options.
Edit files with legacy data connections
You can now edit files that contain legacy data connections like Text Queries, Web Queries, Query Table, or SharePoint Lists. This enables interaction with the workbook and access to the previously stored data from these connections, but without interaction, modification, or refreshing of the connections themselves. We recommend switching to import data via Power Query to connect and refresh data.
Edit files with legacy Shared Workbook feature
You can now edit files that use the legacy shared workbook feature, with a provision for one-click turn-off of the legacy feature, thus allowing you to interact and collaborate with the workbook.
Delete chart elements
Deleting a data series from charts is now easier by selecting a series and pressing the delete/backspace key to remove it.
Multiline formula bar
Users can now expand and collapse the formula bar by using the chevron or manually resizing it. This capability Improves the readability of long formulas or text
New Excel Functions
IMAGE Function (Insiders Beta)
Improvements to the connected Power BI experience (Insiders Beta)
Show Changes (Insiders CC Preview)
New Excel Functions
IMAGE Function (Insiders Beta)
Show Changes (Insiders CC Preview)
