How to Trace Formulas in Google Sheets

There are a couple hidden secrets about Google Sheets that a lot of people don’t know, even some power users who use it daily. One of those is that tracing formulas is really easy in Google Sheets. In fact, it’s even easier than doing so in Excel unless you use some sort of Excel plug-in like Macabacus or Factset.

Two Ways to Trace Formulas

There are two ways to trace formulas in Google Sheets: the native F2 method that’s built right in, and using a Chrome extension for more complex auditing.

Option 1: The Native F2 Method

Hit F2 on a cell and it opens the formula editor. You’ll see all the references highlighted. Put your cursor on one of those references and hit F2 again — it’ll jump you to that cell, even across tabs. Super fast for simple formulas.

The only annoying thing about this is there’s no way to fully navigate to the source cell. Sheets will show you where the cells are located, but it always takes you back to the original cell you were auditing — then you have to go manually find the tab and cell you were looking for.

Option 2: Use a Google Sheets Extension

An extension like XLKeys has a built-in Trace Precedents feature which is activated via a keyboard shortcut, just like Macabacus in Excel. Once activated, you can trace through the formula like normal, then press Enter to go to an input cell and it will navigate you to that position in the workbook — or press Escape to go back to your original cell.

When to Use Which

If you’re navigating complex formulas or workbooks — which is becoming even more commonplace now with AI-created spreadsheets that tend to have long, unreadable formulas — using an extension like XLKeys will be the most useful. If you’re just trying to see where a simple two-input formula is coming from, just use F2.