Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
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.