Share this article

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

These new Excel features were added in July

3 min. read

Published onJuly 27, 2022

published onJuly 27, 2022

Share this article

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

Another month bringsanother set of updates and new Excel featuresand an announcement that the Natural Language Query improvements that have been promised are now generally available for both Mac and Windows operating systems.

Among the list of July 2022 updates Microsoft is noting that Excel for the web now supportssearch for fields in PivotTable fieldlist. Users can now manually search for and select desired data to add to a pivot table via the Excel web app, which should help speed up sorting processes for millions.

Next up, Microsoft is testing the ability tocontrol automatic data conversionsin the Insider Beta channel for Excel.

For those lucky enough to receive the improvement will now be met with additional settings to prevent specific types of data from being converted. In practice, users will need to enable the feature by going to File > Options > Advance> Automatic Data Conversion, and then choosing which conversions they would like to disable.

It’s not free for fall buffet of conversion options that can be disabled, but here are the handful of selections users can choose from:

Since it’s an Insider release, there are some caveats to be noted, such as it being a Windows only roll out for now and known issues that include the Excel team working to bring support for disabling conversions during Macro executions as well as support for automatic conversion to dates.

For those interested, be on the lookout forOffice Insider build 15427.200000or later.

As previously mentioned, Microsoft is rolling outNatural Language Query improvementsfor Windows and Mac users in the Current and Monthly Enterprise Channels.

What does it mean?

For anyone in those available channels they will now able to try asking Excel questions about specific patterns or insights in their own data with relatively natural sentencing like, “Show me insights for the Northwest region.”

Excel will provide a list of suggested questions that users can modify to their own intent in the Analyze Data settings. To get to the new feature, users will need to select adata range > select the Analyze Data button on the Hometab.

To get additional data from a question, users will need to type in their query at the top of the Analyze Data settings pane and will then receive additional PivotTables, tables and charts.

Fret not Mac users, there are couple of features that came down the pipe in July that included Resizable Conditional Formatting dialog boxes.

While a relatively minor update, it’s still a nice attention to detail improvement that’s a long time coming. Instead of selecting from the five conditional formatting rules, users can now freely resize the dialogue box to their specificities.

Unfortunately, the improvement is only for users of the Insider Beta channel. However, if you’re in the Insider Beta channel be on the lookout Version 16.64 and build number 22070600 or later.

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.

Kareem Anderson

Networking & Security Specialist

Kareem is a journalist from the bay area, now living in Florida. His passion for technology and content creation drives are unmatched, driving him to create well-researched articles and incredible YouTube videos.

He is always on the lookout for everything new about Microsoft, focusing on making easy-to-understand content and breaking down complex topics related to networking, Azure, cloud computing, and security.

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Kareem Anderson

Networking & Security Specialist

He is a journalist from the bay area, now living in Florida. He breaks down complex topics related to networking, Azure, cloud computing, and security

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#

These new Excel features were added in July#