Trace all direct and indirect formula precedents and dependents for the selected range. Works with named ranges and importrange.
What do you do when someone shares a spreadsheet with you that has many formulas? You click on the cell with the result you're interested in, make note of the cells in the formula, then go to those cells and repeat the process (going back and forth to ranges throughout the tabs in the sheet - getting lost in the process) until you finally identify all the cells that feed into the cell(s) you really care about.
Formula Tracer's Find Precedents button does all that for you automatically. It will even identify formulas in referenced ranges. For a simple example, a cell has the formula, =sum(A1:B5). Find Precedents will look at all the cells in A1:B5, find the ones that have formulas, then show you where those formulas, in turn, come from.
The results are displayed as a cascading tree of cell addresses. You can click on each node of the tree and be taken directly to that cell in the sheet - no matter the tab. Hovering over a node will also show all the formulas for all the cells that feed into that cell.
We offer a free 5-day trial, so please give Formula Tracer a try now!
Extore is a team of professionals who are passionate about creating extensions for web browsers. This devotion also gives us opportunity to appreciate work of other people. We get inspired by useful, open source extensions made by developers all over the world. Our strong belief is that one should share helpful add-ons with others. That’s why we’d like to present you our ever-growing list of favourite extensions that have inspired us. Moreover, as you probably have already learned, sometimes struggling for the best brings an end to the good. Talking about add-ons it often turns out that an upgrade is worse then previous version. Also it can become really tricky to get back to the beloved version of your favourite extension. That’s why we’re going to make not only the latest, but all versions of our favourite (and we hope yours too) add-ons available for download. No more compromises, just stick to the version you really like!
Preparing download link, please wait for seconds
Almost done...
Click to download
Error getting file. Please try again
