Microsoft Office Tutorials and References
In Depth Information
Creating a Formula Using Formula AutoComplete
Did You Know?
Pointing to cells reduces errors. When building formulas, pointing to
a cell rather than typing its address ensures that the correct cell is refer-
You can print formulas. Click the Formulas tab, click the Show For-
mulas button to show formulas, click the File tab, click Print, and then
click Print.
Creating a Formula Using Formula AutoComplete
To minimize typing and syntax errors, you can create and edit formulas with Formula
AutoComplete. After you type an = (equal sign) and begin typing to start a formula, Excel
displays a dynamic drop-down list of valid functions, arguments, defined names, table
names, special item specifiers—including [ (open bracket),, (comma), : (colon)—and text
string that match the letters you type. An argument is the cell references or values in a for-
mula that contribute to the result. Each function uses function-specific arguments, which
may include numeric values, text values, cell references, ranges of cells, and so on.
Enter Items in a Formula Using Formula AutoComplete
Click the cell where you want to enter a formula.
Type = (an equal sign), and beginning letters or a display trigger to start For-
mula AutoComplete.
For example, type su to display all value items, such as SUBTOTAL and
The text before the insertion point is used to display the values in the drop-
down list.
As you type, a drop-down scrollable list of valid items is displayed.
Icons represent the type of entry, such as a function or table reference, and a
ScreenTip appears next to a selected item.
To insert the selected item in the drop-down list into the formula, press Tab or
double-click the item.
Search JabSto ::

Custom Search