Everything new for Microsoft Excel from July 2022

Microsoft rolled out several features for Excel this month, including new tools for Insiders and general users.

When you purchase through links on our site, we may earn an affiliate commission.Here’s how it works.

What you need to know

What you need to know

Microsoft rolls out new features to all of its Office apps each month. While Excel might not get as many new features as Microsoft Teams, it still gains new capabilities on a regular basis. In July 2022, Microsoft added several new features to Excel for the web, Windows, and Mac, all of which are summarized in aTech Community post.

Excel users on the web can now search for fields within PivotTables. This should make it easier to find content, though it might take some time to roll out to everyone.

On Excel for Windows and Mac, Microsoft improved Natural Language Query support. The feature allows users to search for information within a spreadsheet with everyday language. The company has a dedicatedsupport pageto help people get started.

Office Insiders on Windows can test out an improved set of tools for automatic data conversion. Specifically, users can choose how and when data is automatically converted.

Insiders on Mac will have the option to see more choices for resizable conditional formatting at once. The dialog box for the feature can now be expanded vertically or horizontally, which lets it show more rules at a time.

Here’s everything that’s new for Excel for the web, Windows, and Mac:

Excel for the web

Get the Windows Central Newsletter

Get the Windows Central Newsletter

All the latest news, reviews, and guides for Windows and Xbox diehards.

Excel for Windows

Excel for Mac

If you aren’t already an Office Insider, you can sign up to become one onMicrosoft’s website.

Sean Endicott is a tech journalist at Windows Central, specializing in Windows, Microsoft software, AI, and PCs. He’s covered major launches, from Windows 10 and 11 to the rise of AI tools like ChatGPT. Sean’s journey began with the Lumia 740, leading to strong ties with app developers. Outside writing, he coaches American football, utilizing Microsoft services to manage his team. He studied broadcast journalism at Nottingham Trent University and is active on X @SeanEndicott_ and Threads @sean_endicott_.