Here are all the new features Microsoft added to Excel in July 2022

Excel logo with green background

Every month, Microsoft publishes a roundup of all the features that it added to Excel throughout the course of the past four weeks. And while July isn't over yet, it seems like Microsoft had added all the capabilities planned for this month, as it has penned a blog post explaining everything it did in July 2022.

Starting off with Excel for the web, there is a new search box for fields in PivotTables. You'll find this particularly useful if you have a long list of fields to scroll through.

A screenshot showing Excel automatic data conversion settings

Coming over to Excel for Windows, there's a nifty configuration that enables you to control when and how data is automatically converted when you bring it into Excel. This is currently only available for Beta Insiders, you can check out a screenshot above.

Meanwhile, Current Channel and Monthly Enterprise Channel customers can give natural language queries a go. It has been improved to be able to cater to questions about specific patterns. Simply stated, you can use the "Analyze Data in Excel" option to ask questions about your data in natural language and get better insights in response.

Finally, Excel for Mac has the same natural language improvements described above. But, Beta Insiders can also resize the dialog box for the Manage Rules conditional formatting options. Previously, this showed only five rows at a time and formulas would get cut off too. Now, you can resize it to take advantage of more real estate on your display.

You can share your feedback about existing features in Microsoft Excel and request for new ones through the dedicated portal here.

Report a problem with article
Microsoft logo on a dark background with stacks of cash at the bottom
Next Article

Microsoft posts strong quarter but blames global conditions for some financial results

windows 10 update
Previous Article

Latest Windows 10 update KB5015878 improves OS upgrade experience, fixes DX12 issue

3 Comments - Add comment

Advertisement