Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Wizard to Display and Fix Worksheet Errors

Summary: Easily display and fix possible errors in your Microsoft Excel 2003 worksheets.

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.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Functions and Formulas page.

Print this tip.

- Subscribe!

Search the Site: