Microsoft today announced the new features the company added to Excel in July 2022.
Chief amongst these is Excel Live, an enhanced collaboration solution for working on Excel workbooks in real time with your Teams meetings.
Microsoft also announced the general availability of Natural Language Query improvements in Excel for Windows and Mac as well as the rolling out of setting automatic data conversions (Excel for Windows) and resizable conditional formatting dialog (Excel for Mac) to Insiders.
Here’s what’s new:
Excel for the web
Search for fields in PivotTable Field List
Microsoft is rolling out an update to the PivotTable field list in Excel for the web to enable users to easily search for fields in their PivotTables. If you don’t see this feature yet, it’s coming soon.
Search for fields in PivotTable field list
Excel for Windows
Control automatic data conversions (Insiders Beta)
Microsoft is rolling out an improvement in Excel for Windows to give you more control over data conversions. More specifically, you can now control how and whether the data you enter is automatically converted to specific formats.
Set automatic data conversions
Natural Language Query improvements (Current Channel & Monthly Enterprise Channel)
Take advantage of the latest natural language processing innovations, you can now ask questions about specific patterns or insights that might be in your data like “Show me insights for the Northwest region”. You get more options when there are multiple answers to your question.
Excel for Mac
Natural Language Query improvements
Ask questions about specific patterns of insights that might be in your data like “Show me insights for the Northwest region” and get more options when there are multiple answers to your question.
Resizable Conditional Formatting dialog (Insiders Beta)
Previously, the size of the Manage Rules dialogue limited you to viewing just five conditional formatting rules at a time. You may also not be able to see the entire formula or the range used in your rules. Now, you can make the dialogue wider and/or taller, allowing you to see more of the rules all at once and giving you more space to view longer formulas if needed.
In addition, this update improves accessibility by making it easier to use your keyboard to manage your conditional formatting rules.
Resize the Conditional Formatting dialogue box
The updated features are rolling out now.
