Microsoft Office Tutorials and References

In Depth Information

**Evaluating Part of a Formula**

Excel in Practice: Moving the Formula Tooltip

Excel in Practice: Moving the Formula Tooltip

As you type a formula, Excel 2013 offers a tooltip to show the order

of the arguments for a function. As shown in
Figure 9.34
, this tooltip

can frequently get in the way by covering nearby cells.

Figure 9.34.

Figure 9.34.
The tooltip is covering adjacent cells.

The tooltip is covering adjacent cells.

Tip

If you click the function name in the tooltip, Excel opens the Help top-

ic for that function.

A cool trick is to click the tooltip and drag it to a new location. As

you continue entering the formula, the tooltip stays in the new, de-

tached location (see
Figure 9.35
)
.