Formula Tracer

Formula Tracer 11 CRX for Google Sheets

A Free Utilities Add-on

Published By

Formula Tracer (mfilboegnkfcgafdcaonhkkgopklgoop): Trace both direct and indirect formula precedents and dependents. Works with named ranges and importrange. ... Read More > or Download Now >

Formula Tracer for Google Sheets

Download CRX


7.40 KB


Tech Specs

  • • Type: Google Sheets Add-on
  • • Latest Version: 11
  • • Price: Freeware
  • • Offline: No
  • • Developer:

User Reviews

  • ★★★☆☆
  • • Rating Average
  • 3.5 out of 5
  • • Rating Users
  • 6

Download Count

  • • Total Downloads
  • 15
  • • Current Version Downloads
  • 8
  • • Updated: April 24, 2019

Formula Tracer is a free Utilities Add-on for Google Sheets. You could download the latest version crx file or old version crx files and install it.

More About Formula Tracer

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!

More Add-ons to Consider (Similar or Related)