Site icon TheWindowsUpdate.com

What’s New in Excel (March 2023)

This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .

Welcome to the March 2023 update. This month, we are excited to announce several new features across web, Windows, and Mac. For web users, speed up large workbooks with Check Performance, insert and edit formulas with Formula Argument Assistance, and enhance your query organization with Drag & Drop in Queries Pane. Block untrusted XLL Add-Ins has launched to all Windows users, while Assign a Task with @mentions is now available for Windows and Mac users.

 

Also, now that college basketball excitement is in full swing, check out this College Basketball Random Bracket - try them with family and friends.

 

Excel for the web:

Excel for Windows:

Excel for Mac

Excel for the web

Check Performance

When you open your workbook, Excel can detect whether your workbook contains unwanted formatted cells that can slow down your workbook. If so, Excel suggests launching “Check Performance.“ You can also manually launch the feature from Review > Check Performance. Read the blog article, and see it in action here >

Check Performance

Formula Argument Assistance

Formula Argument Assistance card accompanies you while writing a formula, and helps you insert or edit the arguments.

You no longer need to reach out to external sources for help when you are typing your formula! The Argument Assistance card will help you write formulas more efficiently and reduce errors. Read more >

Formula Argument Assistance

#FIA!

Drag & Drop in Queries Pane 

Drag & Drop in the Queries pane enhances your ability to organize your queries - you can easily sort queries or move them between folders.

Drag & Drop in Queries Pane

Excel for Windows

Block untrusted XLL Add-Ins

This feature adds a layer of security to your worksheets. It protects you from potential attacks coming through XLL add-ins, a particular type of add-in that is being used to distribute malware to unsuspecting victims. Read more >

Block untrusted XLL Add-Ins

Assign a Task with @mentions 

Assign a Task allows users to collaborate more effectively with their teams by creating and assigning tasks within their Excel worksheets and Word documents using @mentions in comments and tagging a team member.   

Once a team member is assigned the task (by selecting the ‘Assign to’ check box to the comment to convert to a task and then clicking the blue arrow), they receive an email notification to let them know they have tasks to action. Read more >

Assign a Task

Excel for Mac

Assign a Task with @mentions 

Assign a Task allows users to collaborate more effectively with their teams by creating and assigning tasks within their Excel worksheets and Word documents using @mentions in comments and tagging a team member.   

Once a team member is assigned the task (by selecting the ‘Assign to’ check box to the comment to convert to a task and then clicking the blue arrow), they receive an email notification to let them know they have tasks to action. Read more >

Assign a Task

 

 

Check if a specific feature is in your version of Excel

Click here to open in a new browser tab

 

 

 

Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown.  You can also submit new ideas or vote for other ideas via Microsoft Feedback.

 

Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.

Exit mobile version