Auditing Toolbar
The Auditing Toolbar is one if Excel's best kept secrets. It allows you to visualize the cells used in any formula. In particular is allows you to view what cells are being used by a particular formula, what other cells are relying on the cell you have specified, follow links to other spreadsheets and more recent versions of Excel include some error checking capabilities.
Views: 875 | | by Mark
View this tutorial