Blog

Excel | Formula Argument Assistance

Written by Myles Arnott | Apr 3, 2023 2:18:00 PM

A handy new tool for making it easier to use Excel functions, and therefore reduce mistakes

 

Microsoft has recently released "Formula Arguement Assistance" into Excel for the web.

This helpul new feature pops up a formula reference card when you start to write a function:

As well as walking you thorugh the function syntax as you write a formula it also highlights the relevant argument when you are editing a formula:

 

The card can be minimised back to just the core function syntax if you don't need assistance with the function.

[Images from Micosoft Tech Community post]

My thoughts

This feels like another great addition to Excel. Anything that can make the writing of formulae easier for Excel users, and thus reduce the risk of error, can only be a good thing.

Release date

The "Formula Arguement Assistance" feature is currently only available in Excel for the web. It will be added to Excel desktop versions.

See the full article from the Microsoft Tech Community here.

Our Future of Excel series

This series of articles focuses on new features soon to be released on Excel. This is based on announcements by the Microsoft Office Insider team.

See other articles in our Future of Excel series here.