Welcome toExcel2007.Tips.Net
Helpful Links
Cleaning Tips
Cooking Tips
Gardening Tips
Money Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
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:
- Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
- Click Formulas at the left side of the dialog box. (Click here to see a related figure.)
- Clear the Enable Background Error Checking check box.
- Click OK.
Any existing green triangles should disappear, and Excel stops checking for errors.
Related Tips:
Create and Merge! Using Word's mail merge tool you can quickly and easily combine data from a variety of data sources to create great individualized documents that incorporate your data in ways that you control. WordTips: Mail Merge Magic is an invaluable source for learning how to harness the full power of Word's mail merging capabilities. Check out WordTips: Mail Merge Magic today!