Microsoft Office Tutorials and References
In Depth Information
In addition to displaying function names, the Formula AutoComplete feature also lists
cell and range names and table references. See Chapter 3 for information on names and
Chapter 9 for information about tables.
After you press Tab to insert the function and its opening parenthesis, Excel displays another ScreenTip that
shows the arguments for the function (see Figure 4-2). The bold argument is the argument that you are entering.
Arguments shown in brackets are optional. Notice that the text in the ScreenTip contains a hyperlink for each
argument that you've entered. Click a hyperlink to select the corresponding argument. If that ScreenTip gets in
your way, you can drag it to a different location.
If you don't like using Formula AutoComplete, you can disable this feature. Choose File ⇒ Options to display the
Excel Options dialog box. On the Formulas tab, remove the check mark from the Formula AutoComplete op-
Figure 4-2: Excel displays a list of the function's arguments.
When you type a built-in function, Excel always converts the function's name to upper-
case. Therefore, it's a good idea to use lowercase when you type function names manu-
ally. If Excel doesn't convert your text to uppercase after you press Enter, your entry
isn't recognized as a function, which means that you spelled it incorrectly or that the
function isn't available. For example, it may be defined in an add-in that is not currently
Using the Function Library commands