Excel Tips: Tracing Formulas

“Trace Dependents” and “Trace Precedents” are terrific ways to audit a large workbook.  We use these frequently when we inherit complicated spreadsheets from others.  These tools allow you to quickly view which cells and formulas in the entire workbook pull from the target cell in question.

Comments are closed.