What you need to know
- Microsoft rolled out several features for Excel in July 2022, including improved Natural Language Query support.
- New tools are available for Excel for the web, Windows, and Mac.
- Insiders can test out the option to set automatic data conversions and use a resizable conditional formatting dialog.
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 a Tech Community post (opens in new tab).
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 dedicated support page (opens in new tab) to 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
- Search for fields in PivotTable field List
Excel for Windows
- Control automatic data conversions (Insiders Beta)
- Natural Language Query improvements (Current Channel & Monthly Enterprise Channel)
Excel for Mac
- Natural Language Query improvements
- Resizable Conditional Formatting dialog (Insiders Beta)
If you aren't already an Office Insider, you can sign up to become one on Microsoft's website (opens in new tab).
Sean Endicott is the news writer for Windows Central. If it runs Windows, is made by Microsoft, or has anything to do with either, he's on it. Sean's been with Windows Central since 2017 and is also our resident app expert. If you have a news tip or an app to review, hit him up at firstname.lastname@example.org.
Get the best of Windows Central in in your inbox, every day!
Thank you for signing up to Windows Central. You will receive a verification email shortly.
There was a problem. Please refresh the page and try again.