Let us help you make the most of your data investments
Your spreadsheet formulas are a major component of your analysis, processes, and functionality. They have to be right.
Activate the add-on and you’re ready to go.
Instantly find what makes up your formula as well as what depends on a particular cell.
Click on a formula within your spreadsheet, click the Find Precedents or Find Dependents button, and immediately see every formula, cell, named range, and element that goes into making up the number you see on your screen.
Easily jump to and from the components that make up a formula by clicking on the node in the Formula Tracer window. You can navigate to components on the same sheet, on a different sheet, or in a completely different workbook.
Named ranges can have a major impact on both the functionality and understandability of spreadsheet functions. Our Formula Tracer includes named ranges when they’re included in a formula, showing how they’re utilized in a formula as well as the definition of the named range.