Microsoft Office Tutorials and References
In Depth Information
Using Formula AutoComplete
Using Formula AutoComplete
Excel 2007 introduced a useful feature known as Formula AutoComplete. When you type an
equal sign and the first letter of a function in a cell, Excel displays a drop-down list box that
contains all the functions that begin with that letter. You also see a ScreenTip with a brief description
for the function (see Figure 68-1).
Figure 68-1: When you begin to enter a function, Excel lists available functions that begin with the typed
When the AutoComplete list is displayed, you can continue typing (to narrow the number of
items displayed in the list) or use the arrow keys to select the function from the list. After you
select a function, press Tab (or double-click) to insert the function and its opening parenthesis
into the cell.
In addition to displaying function names, the Formula AutoComplete feature lists
names and table references.
After you press Tab to insert the function, Excel displays another ScreenTip, which shows the
arguments for the function (see Figure 68-2). The bold argument is the argument you are
currently entering. Arguments shown in brackets are optional. If the ScreenTip gets in your way, you
can drag it to a different location.
Search JabSto ::

Custom Search