Error Checking

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.

   Tracing Errors
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.

This Site

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.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.