How to Find Cells Used in Formulas in Excel – Tutorial

We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)

Excel tutorial on how to find cells used in formulas in Excel using Trace Precedents and Trace Dependents.

Sometimes spreadsheets end up with sooo many numbers and formulas that it can be confusing figuring out which formulas are affected by which cells.

Using an example, we’ll go over how to use the Trace Precedents and Trace Dependents features in Excel to help us figure out which cells are used in formulas in our spreadsheet.