Welcome toExcel2007.Tips.Net
Helpful Links
Gardening Tips
Home Tips
Organizing Tips
Pest 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
Setting Rules for Error Checking
Summary: Excel can check the data and formulas in your worksheet to see if it detects any errors. The rules used for this checking can be modified, if you desire.When Excel does background checking of your worksheet for errors, it follows a set number of rules. You can modify the rules that Excel follows through 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.)
- Make sure the Enable Background Error Checking check box is selected.
- Clear or set the checkboxes in the Error Checking Rules area of the dialog box, each of which specifies a different error-checking rule that Excel can follow.
- Click OK.
Related Tips:
Take Control! Master the real power behind Word! Successfully master the secrets of powerful formatting and create documents that stand out from the rest. Best of all, you can create documents that are easy to maintain and quick to change. Check out Word 2007 Styles and Templates today!