Excel formula tips: How to troubleshoot by tracing dependents and precedents

When your spreadsheet has formulas piled on top of formulas, tracking and repairing errors would be agony if it weren’t for Excel’s Precedents and Dependents: cells that are referred to by a formula in another cell, and cells that contain formulas that refer to other cells, respectively. The next time you need to find out how the(…)