Tips, Tricks, and Answers
The following articles are available for the 'Error Checking' topic. Click the article''s title (shown in bold) to see the associated article.
Empty Cells Triggers Error
By default, Excel provides some feedback on your formulas so that you can easily locate potential errors. If you get tired of Excel pointing out some of these errors, you can adjust how it does its checking.
Sometimes it can be confusing to figure out the source of an error that is displayed in your worksheet. Excel provides a quick tool that can help you get closer to the error's source.