Share this article

Latest news

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Everything new in Microsoft Excel for the month of December 2022

3 min. read

Published onDecember 21, 2022

published onDecember 21, 2022

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

In this article

Toggle

We are almost at the end of 2022, and Microsoft has been adding a plethora of features to Excel in a bid to enhance its user experience. And this month isn’t any different, Microsoft releaseda bunch of nifty features to Excel for the month of December. Here’s everything you need to know:

Excel for the web

Microsoft has incorporated a neat feature in Excel for web users, Formula suggestions. Essentially,  after hitting the “=” sign in a cell or the formula bar, you’ll now get automatic suggestions for the best formula to use. This will be based on contextual insights from your data. At the moment, you’ll get suggestions for the following formulas: SUM, AVERAGE, COUNT, COUNTA, MIN, and MAX.

Next up is Formula by Example. This feature is designed to establish a pattern while users are performing manual and repetitive data entry in a column. In the event that Excel identifies one, it will suggest to the user to complete the entire column with a formula. Just like Flash Fill, but this time, its formulas being suggested not static text.

Moreover, users will now be able to correct broken links with the new Suggested Links feature. “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,” says Microsoft. Suggested links is rolling out to Production at the moment.

Excel for web users will also be able to make queries easily with the newly added search bar in the queries pane. And finally, with the IMAGE function, users will be able to add images to cells from a source location together with the alternative text.

Thus making it easier to feature images in the worksheet instead of having them float at the top, what’s more, you can move, sort, filter as well as resize the images within the Excel table.

Excel for Windows

Microsoft has added a new shortcut for Excel for Windows that will allow them to open the Power Query Editor easily. That is: PressAlt+F12(Win32).

Next up is the new capability to create nested Power Query data types that will allow users to arrange and manage their data better. Unfortunately, this feature is only rolling out to Insiders at the moment.

Furthermore, Microsoft has added support for Get Data from Table/Range. In turn, users can import data from Dynamic Arrays, thus allowing them to load them into Power Query and transform the data. At the moment this feature is rolling out to Windows Production. And finally, Excel for Windows is also getting the IMAGE function.

Excel for Mac

Excel for Mac now has a new shortcut that will help users to easily open the Power Query Editor. Simply pressOption+F12. Likewise, Mac users will also be able to access the IMAGE function.

To get information on which features are available to you or find which version of Excel you’re on, you can visit theExcel Features Flyersite. That’s it for the month of December folks! Be sure to also check outlast month’s postin case you missed it.

Radu Tyrsina

Radu Tyrsina has been a Windows fan ever since he got his first PC, a Pentium III (a monster at that time).

For most of the kids of his age, the Internet was an amazing way to play and communicate with others, but he was deeply impressed by the flow of information and how easily you can find anything on the web.

Prior to founding Windows Report, this particular curiosity about digital content enabled him to grow a number of sites that helped hundreds of millions reach faster the answer they’re looking for.

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Δ

Radu Tyrsina