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-
enced.
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
SUM.
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