skip to Main Content

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.
 

This post is only available to members.
Back To Top