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-
tion.
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
installed.
Using the Function Library commands
Search JabSto ::




Custom Search