What’s New in Excel (August 2022)

Posted by

This post has been republished via RSS; it originally appeared at: Excel Blog articles.

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.

 

Check out this Excel Features Flyer to find if a specific feature is in your version of Excel

 

Excel for the web

  • New Excel Functions
  • Power Query Group operations
  • Improvements to the connected Power BI experience
  • Add and edit rich text formatting
  • Sort by color or icon from auto filter menu
  • Edit files with legacy data connections
  • Edit files with legacy Shared Workbook feature
  • Delete chart elements
  • Multiline formula bar

Excel for Windows

  • New Excel Functions
  • IMAGE function (Insiders Beta)
  • Improvements to the connected Power BI experience (Insiders Beta)
  • Show Changes (Insiders CC Preview)

Excel for Mac

  • New Excel Functions
  • IMAGE function (Insiders Beta)
  • Show Changes (Insiders CC Preview)

Android

  • New Excel Functions
  • IMAGE function (Insiders Beta)

iOS

  • New Excel Functions
  • IMAGE function (Insiders Beta)

 

Excel for the web

New Excel Functions

14 new functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are now rolling out to users. Read more >

Text manipulationText manipulation

 

 

Power Query Group operations

You can now perform various operations on Power Query groups to better organize your queries and easily consume the data on the queries pane. Read more >

Power Query group operationsPower Query group operations

 

Improvements to the connected Power BI experience 

In both Excel for the web and Excel for Windows, you can create a PivotTable that connects directly to a Power BI dataset. This allows you to analyze data between platforms seamlessly. With this set of updates, we improve the experience of analyzing data in PivotTables. Read more >

Power BI connected PivotTablePower BI connected PivotTable

 

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.

Edit rich textEdit rich text

 

Sort by color or icon from auto filter menu

Sorting is now easier and more convenient with new sort-by-color or icon options.

Sort by color or icon from auto filter menuSort by color or icon from auto filter menu

 

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 data connectionsEdit files with legacy data connections

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. 

Edit files with legacy Shared WorkbooksEdit files with legacy Shared Workbooks

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.

Delete chart elementsDelete chart elements

 

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 

Multiline formula barMultiline formula bar

 

Excel for Windows

New Excel Functions

14 new functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are rolling out to users in the Current Channel. Read more >

 

IMAGE Function (Insiders Beta)

The image function inserts images into cells from a source location, along with the alternative text. Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort and filter, and work with images within an Excel table. Read more >

Insert Image FunctionInsert Image Function

 

Improvements to the connected Power BI experience (Insiders Beta)

In both Excel for the web and Excel for Windows, you can create a PivotTable that connects directly to a Power BI dataset. This allows you to analyze data between platforms seamlessly. With this set of updates, we improve the experience of analyzing data in PivotTables. Read more >

 

Show Changes (Insiders CC Preview)

Show Changes in Excel lets you see exactly what edits were made to your workbooks, so you can confidently allow others to collaborate on your work. You can see details of who changed what, where, and when, along with the previous value of the cell for quick reversion. Now available in the CC Preview Channel for Insiders. Read more >

Show ChangesShow Changes

 

Excel for Mac

New Excel Functions

14 new functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are now rolling out to users. Read more >

 

IMAGE Function (Insiders Beta)

The image function inserts images into cells from a source location, along with the alternative text. Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort and filter, and work with images within an Excel table. Read more >

 

Show Changes (Insiders CC Preview)

Show Changes in Excel lets you see exactly what edits were made to your workbooks, so you can confidently allow others to collaborate on your work. You can see details of who changed what, where, and when, along with the previous value of the cell for quick reversion. Now available in the CC Preview Channel for Insiders. Read more >

 

 

Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown.  You can also submit new ideas or vote for other ideas via Microsoft Feedback.

 

Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.

 

Check out this Excel Features Flyer to find if a specific feature is in your version of Excel


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.