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
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 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 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 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 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 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 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 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 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 bar
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 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 Changes
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.
Continue reading...
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
- 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)
- New Excel Functions
- IMAGE function (Insiders Beta)
- 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 manipulationPower 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 operationsImprovements 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 PivotTableAdd 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 textSort 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 menuEdit 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 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 WorkbooksDelete 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 elementsMultiline 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 barExcel 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 FunctionImprovements 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 ChangesExcel 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 |
Continue reading...
Last edited:
