Microsoft KB Archive/289146

= How to turn off Function Argument ToolTips in Excel =

Article ID: 289146

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q289146





SUMMARY
In Microsoft Excel, you can complete functions with the aid of the ToolTip feature. This feature displays ToolTips by default when you begin to type a formula in the formula bar. These ToolTips also make it easier to obtain additional help for a given function by allowing you to click the function name in the ToolTip and jump directly to its associated Help topic.

This article explains how to turn off these function ToolTips in Microsoft Excel 2002 and in later versions of Excel. When you do this, you can type the function in the formula bar without assistance. .

How to turn off function argument ToolTips in Microsoft Excel 2002 and in Microsoft Excel 2003
To do this, follow these steps:
 * 1) On the Tools menu, click Options.
 * 2) In the Options dialog box, click the General tab.
 * 3) Click to clear the Function tooltips check box, and then click OK.

How to turn off function argument ToolTips in Microsoft Office Excel 2007
When you begin to type a formula into a cell in Excel 2007, the Formula AutoComplete function provides a drop-down list of formulas. After you have typed a formula into a cell and you begin to type an argument for the formula, the function ScreenTips function provides a list of required and optional arguments for the formula.

This section describes how to turn off the Formula AutoComplete function and the function ScreenTips function.

To turn off the Formula AutoComplete function, follow these steps:
 * 1) Click the Microsoft Office Button, click Excel Options, and then click Formulas.
 * 2) Click to clear the Formula AutoComplete check box.

To turn off the function ScreenTips function, follow these steps:
 * 1) Click the Microsoft Office Button, click Excel Options, and then click Advanced.
 * 2) In the Display area, click to clear the Show function ScreenTips check box.

Additional query words: OfficeKBHowTo inf XL2002 disable unavailble xl2007 XL2003

Keywords: kbhowtomaster KB289146

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.