1-866-245-5224 sales@keystonelearning.com

Excel 2003: Tracing Errors

Excel 2003: Tracing Errors

Even the best of us run into errors now and then when using Excel. And, usually they look something like this:

But, by using the Trace Errors command, you can quickly see where the formula is grabbing its arguments. Often, just being able to visually see what cells a formula is referencing is enough to help you rectify the problem.

Tracing Errors

     
  1. Click any cell containing a formula with errors
     
  2.  
  3. Click Trace Error command on the Formula Auditing toolbar
     

Removing Error Tracers

     
  1. Click the Remove All Arrows command on the Formula Auditing toolbar