Chapter 9: Introducing Formulas and Functions
9
FIGURE 9.2
Excel displays a drop-down list when you enter a formula.Using Formula AutoComplete
The Formula AutoComplete feature makes entering formulas easier than ever. Simply start typing
your formula, and Excel will help by presenting you with a list of the possible options and arguments
available. In this example, Excel is presenting the options for the SUBTOTAL function.
Formula AutoComplete includes the following items (and each type is identified by an icon):
■ Excel built-in functions.
■ User-defined functions (functions defined by the user through VBA or other methods).
■ Defined names (cells or range named using the Formulas ➪ Defined Names ➪ Define Name
command).
■ Enumerated arguments that use a value to represent an option. (Only a few functions use
such arguments, and SUBTOTAL is one of them.)
■ Table structure references (used to identify portions of a table).