Microsoft upgrade web version of Excel table software: windowing to create and edit formulas

CTOnews.com October 26, Microsoft recently issued a press release to upgrade the web version of Excel, focusing on improving the experience of formula manipulation in tables, making it easier for users to create and edit formulas.

Insert Formula Dialog Web version of Excel adds the function of inserting Formula Dialog, which makes it convenient for users to select the desired formula content with a graphical prompt interface.

The example of CTOnews.com according to the content of the blog post is as follows: the user selects the addition of U17 to T17 in the table, which previously needed to enter "= SUM (U17:T17)" on the target cell, but now the user can select the action in the graphical interface by means of mouse click.

Microsoft said: "quickly find the function or browse the category to find what you need. Each function has a description and expected parameters, and you can preview the value of each parameter and the complete formula."

Parenthesis coupling: if the formula entered by the user is very long, now after the user selects a small formula, the parentheses outside the current formula will be recognized to help the user identify the formula in a specific area.

Value Preview when you hover over or select a section, the value preview displays values related to any part of the formula in real time, simplifying the evaluation and troubleshooting of the formula.