Welcome to the December 2022 update. We are excited to announce the release of Formula Suggestions and Formula by Example for Excel web users - a couple exciting capabilities designed to help save you time and learn more about Excel formulas as you use them. Also for web users are suggested links, IMAGE function, and a new search bar in the queries pane. For Windows users, a new keyboard shortcut is available to open the Power Query editor, and Insiders users on Windows can now get data from dynamic arrays and create nested Power Query data types to better organize your data.
Curious to see how we at Excel utilize and implement your feedback? You can now see which features are a direct result of your feedback as they'll be marked with the Feedback In Action tile #FIA.
Excel for the web:
Excel for Windows:
- Formula Suggestions
- Formula by Example
- Suggested Links
- Add search bar in queries pane
- IMAGE Function
Excel for Mac:
- Add keyboard shortcut to open the Power Query editor #FIA
- Create nested Power Query data types (Insiders) #FIA
- Add Get Data from Dynamic Arrays (Insiders) #FIA
- IMAGE Function
- IMAGE Function
Excel for the web
Formula Suggestions
After you type the “=” sign in a cell or the formula bar, Excel will auto-suggest the best formula based on contextual insights from your data. Formulas that can be suggested are SUM, AVERAGE, COUNT, COUNTA, MIN, and MAX. There is currently only support for the English language. This feature is rolling out to production for web users.
Formula by Example
As you are performing manual and repetitive data entry in a column, Excel will now suggest you to fill the entire column with a formula in case we identify a pattern. This is similar to Flash Fill, however, instead of static text - now formulas can be suggested.
Suggested Links
Suggested Links allow for new cloud workbook storing for data that detects when an external link to a Cloud workbook is broken and suggests you a new location to fix the broken link. This feature is currently rolling out to Production.
Add search bar in queries pane
Easily find your queries within the Queries search pane.
Search bar in queries pane
IMAGE Function
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 >
IMAGE Function
Excel for Windows
#FIA
Add keyboard shortcut to open the Power Query editor
Press Alt + F12 (Win32) or Option + F12 (Mac) to open the Power Query Editor quickly.
Create nested Power Query data types (Insiders)
#FIA
Organize your data even better, by creating nested data types (Power Query Data Types with multiple levels). This feature is currently rolling out to Insiders users for Windows.
Create nested Power Query data types
#FIA
Add Get Data from Dynamic Arrays (Insiders)
Get Data from Table/Range now supports importing data from Dynamic Arrays – so you can load them into Power Query and transform your data. This feature is currently rolling out to Windows Production.
IMAGE Function
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. The IMAGE function is rolling out to Current Channel users now. Read more >
IMAGE Function
Excel for Mac
IMAGE Function
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. This function is currently rolling out to Mac users now. Read more >
IMAGE Function
Check if a specific feature is in your version of Excel
Click here to open in a new browser tab
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.
Source:
What's New in Excel (December 2022)
Check out what's new in Excel this month
techcommunity.microsoft.com
