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.
Click any cell containing a formula with errors
Click Trace Error command on the Formula Auditing toolbar
Removing Error Tracers
Click the Remove All Arrows command on the Formula Auditing toolbar