bottom
Excel 2007 Tips!
     
Your e-mail address is safe!
Close Note
excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Car Tips
Health Tips
Money Tips
Word2007 Tips

Newest Tips

Negative Elapsed Times

Specifying the Number of MRU Files

Changing Data Series Ordering

Seeing How Excel Evaluates Formulas

Highlighting a Cell if It Contains Specific Text

Filling Shapes with Pictures

Creating a List of Worksheet Formulas

 

Getting Rid of Error Checking

Summary: A little green triangle in the corner of a cell means that Excel thinks there is an error with the cell contents. If those triangles bother you, here's how to turn them off.

While you have Excel 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:

  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.