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.