This month, Microsoft is rolling out some popular new features to Excel on the web

Although many consider Microsoft Excel a relatively traditional tool, nearly every organization around the world uses it for visualization due to its mature toolset and relative ease of use for those familiar with the application. Data and applied computing. Microsoft also offers a web version of Excel that you can use on the go. The company regularly updates it with new features, and now, it plans to bring some popular features to Excel for the web.

Currently, if you write a calculation in the formula bar, you get a help tooltip that lists the arguments for the function you are using. You can click on a parameter or function name to jump to a dedicated Help topic on the right side of the window. A screenshot of the current implementation can be seen above.

To make the experience smoother and minimize errors and lookups, Microsoft is introducing an "Argument Assistance" card UI that automatically becomes visible as you write formulas. This will provide you with a description of the formula and its associated parameters, as well as supporting examples.

The idea is to provide this view directly to you without opening an external resource, as is the case in the current implementation. We have no idea what this card UI will actually look like, but the good news is that even if you don't like it or it takes up too much window space, you can collapse the card and revert to the current tooltip implementation. This preference will also be saved.

Another small but useful change Microsoft is making to the Excel formula bar is that it is becoming multi-row, since you can manually resize it to your liking. This is especially useful when you write lengthy formulas and want to format and indent them to improve readability in the formula bar. This feature is already available in the desktop version of Excel.

Both changes will be officially released in March, but there is no hard release date listed in the Microsoft 365 roadmap yet. The Argument Assistance Card UI currently only lists the web as a target publishing platform, but it will be interesting to see if it also makes its way to the desktop version of Excel at some point in the near future.

The above is the detailed content of This month, Microsoft is rolling out some popular new features to Excel on the web. For more information, please follow other related articles on the PHP Chinese website!