What's New in Excel (March 2023)

AWS

Owner
FPCH Owner
Joined
Nov 19, 2003
Messages
11,228
Location
Florida U.S.A.
Windows 10
Edge 99.0.1150.39
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:

  • Check Performance
  • Formula Argument Assistance
  • Drag & Drop in Queries Pane #FIA

Excel for Windows:

  • Block untrusted XLL Add-Ins
  • Assign a Task with @mentions

Excel for Mac

  • Assign a Task with @mentions
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 >

large?v=v2&px=999.gifCheck 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 >

large?v=v2&px=999.gifFormula 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.

large?v=v2&px=999.gifDrag & 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 >

large?v=v2&px=999.pngBlock 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 >

large?v=v2&px=999.pngAssign 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 >

large?v=v2&px=999.pngAssign 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.

Continue reading...
 
Back
Top