How to use the Error Checking Options button in Excel 2002 or in Excel 2003 (291361)
The information in this article applies to:
- Microsoft Office Excel 2003
- Microsoft Excel 2002
This article was previously published under Q291361 SUMMARY
This article explains the functionality of the Error Checking Options button in Microsoft Excel 2002 and in Microsoft Office Excel 2003.
back to the top
Error Checking Options
The Error Checking Options button is displayed when the formula in an Excel 2002 or an Excel 2003 worksheet cell triggers an error. In addition to the button, the cell itself is marked with a small green triangle in the upper-left corner.
When you click the button, the error type is displayed, followed by the following list of error-checking options:
- Help on This Error: displays information specific to the error type
- Show Calculation Steps: demonstrates all steps leading to the error
- Ignore Error: allows you to accept the formula as entered, without Excel displaying the Error Checking Options smart tag
- Edit in Formula Bar: allows you to edit the formula that is generating the error in the Formula Bar
- Error Checking Options: opens the Options dialog box, where you can select the rules governing error checking
- Show Formula Auditing Toolbar: displays the Formula Auditing toolbar
NOTE: To access most of the preceding options, you can also click Error Checking on the Tools menu.
back to the top
REFERENCESExcel 2002For more information about error types and how to correct them, click Microsoft Excel Help on the
Help menu, type find and correct errors in formulas in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned. Excel 2003
For more information about error types and how to correct them, click Microsoft Excel Help on the Help menu, type find and correct errors in formulas in the Search for box in the Assistance pane, and then click Start searching to view the topic.
For additional information about other option buttons in Excel 2002, click the article numbers below
to view the articles in the Microsoft Knowledge Base:
289148 XL2002: Smart Tag Functionality
291357 How to use the AutoCorrect Options smart tag in Excel
291359 XL2002: How To Use Auto Fill Options Smart Tags
291358 HOW TO: Use the Paste Options Buttons in Excel 2002
291363 XL2002: How to Use the "Insert Options" Button in Excel 2002
| Modification Type: | Major | Last Reviewed: | 5/4/2005 |
|---|
| Keywords: | kbHOWTOmaster KB291361 |
|---|
|