Blog Post

Excel Blog
3 MIN READ

What's New in Excel (December 2022)

msexcel's avatar
msexcel
Icon for Microsoft rankMicrosoft
Dec 20, 2022

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.

 

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

 

Excel for the web:

  • Formula Suggestions
  • Formula by Example
  • Suggested Links
  • Add search bar in queries pane
  • IMAGE Function

Excel for Windows:

  • 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

Excel for Mac:

  • 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.

 

#FIA

Create nested Power Query data types (Insiders)

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.

 

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. 

Updated Dec 20, 2022
Version 3.0