Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Making the Formula Bar Persistent
Selecting Tabs in Dialog Boxes
Pulling Formulas from a Worksheet
When Excel 2002 or Excel 2003 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:
The error-checking rules can be modified in Excel 2007 by following these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2370) applies to Microsoft Excel versions: 2002 2003 2007
Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.