This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Wizard to Display and Fix Worksheet Errors

By default, if Microsoft Excel 2003 thinks that a cell formula contains an error, it will note this by adding a slight shade to the top-left of the table cell. Also, if you move your cursor onto such a cell, an exclamation point will appear. You can click this to show the actual error.

While these slight visual cues may help in diagnosing errors, when developing a complex spreadsheet, they can be easy to miss. Thus, Microsoft Excel 2003 has a wizard that lets you diagnose as many or as few worksheet errors as you wish.

1. Select "Tools" - "Error Checking".

2. An "Error Checking" dialog box will appear explaining the first error found. From here, you can:

* Automatically update formulas (if applicable).

* Get further help on an error.

* Ignore the error.

* Edit the cell in the formula bar.

* Click the "Options" button to choose which errors should be shown.

3. Once you are done dealing with an error, click the "Next" or "Previous" button to navigate to the next or previous error. Or, click the "X" to close the wizard.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Wizard to Display and Fix Worksheet Errors.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.