Error Checking in Microsoft Excel 2003

File

Edit

View

Insert

Format

Tools

Data

Window

- Introduction - - Parts of Microsoft Excel Window - - Functions used in Microsoft Excel - - Custom List - - Goal Seek - - Error Checking - - Groupping/Ungroupping cells - - Forms - - Data Validation - - Filters - - Sorting - - Freeze Panes -

This will open a dialog box with options –

Update formula
To include the remaining cells.
Edit Formula
This allows changing the formula from the formula bar.
Ignore Error
If you want to change the color or want to enable/disable the error checking then click on the Options button on the left bottom of the box.