Turning Off Error Checking

While you have Excel 2002, Excel 2003, or Excel 2007 open, it is constantly checking in the background for potential errors in your worksheets. If an error is located (or, at the least, what Excel thinks is an error), then the cell is "flagged" with a small green triangle in the upper-left corner of the cell.

If you don't want Excel to check for errors, you can turn the feature off by following these steps in Excel 2002 or Excel 2003:

1. Choose Options from the Tools menu. Excel displays the Options dialog box.
2. Make sure the Error Checking tab is displayed. (Click here to see a related figure.)
3. Clear the Enable Background Error Checking check box.
4. Click OK.

You turn off the feature in Excel 2007 by following these steps:

1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
2. Click Formulas at the left side of the dialog box. (Click here to see a related figure.)
3. Clear the Enable Background Error Checking check box.
4. Click OK.

Any existing green triangles should disappear, and Excel stops checking for errors.