Excel 2007 Update: Improvements to the editing formula function part 2_formula AutoComplete

The last introduction, in the Excel user interface, has long remained unchanged in the edit bar has been a new change. Today, I go on to talk about a new feature of Excel 12,--formula autocomplete. (Translator Note: literally "Formula AutoComplete") designed to improve the efficiency of formula editing. In particular, we have set three goals when designing AutoComplete:

Help users create formulas faster

Users do not have to rely on external help to create formulas

Reach 1 and 2 in a way that doesn't interfere with normal use

We used the same user interaction as Excel's VBE and Visual Studio, and were as consistent with their standards as possible.

How does the formula AutoComplete work?

AutoComplete with a drop-down list. It can automatically filter items based on the user's input. Each option in the list has an icon that identifies the category to which the option belongs. (the icon shown in this article is not the final product, just a product.) ）

To illustrate AutoComplete, perhaps the best way to do that is by example. Let's try to experience the AutoComplete process by creating the following formula:

=subtotal (109, data)

When I start to create a formula, I always enter an "=" number first. In this case, I want to insert a subtotal function, so I then type "s". Immediately below the cell, a AutoComplete drop-down list appears with an option headed by the letter "S". The first option for the list is selected, with a hint of a feature description. Here, I just click the tab key, or double-click the option to complete the function input.

But I did not do this, but then entered. When I go to "sub", only the option--substitute and subtotal with "sub" are left in the list. Use the up and down cursor keys to move the selection around the options. In this example, use the DOWN ARROW key to move the cursor to the position of subtotal. The description of the feature in the hint reminds me that a subtotal function has been found.