How to Use Formula Auditing Tools to Determine What Cells Are Part of a Formula (Dependents & Precedents) (Excel 2007 & 2010)
If you need to make changes to a worksheet that contains a lot of formulas, or complex formulas, you may need to know what cells will affect these formulas. You can trace formula ‘Precedents’ and ‘Dependents’ with the click of a button.