SheetTrace - Trace Precedents & Dependents

If you spend your days building financial models, auditing formulas, or navigating complex spreadsheets in Google Sheets, you already know the frustration. One of the most powerful features in Microsoft Excel — the ability to instantly trace where a formula pulls its data from, and to find every cell that depends on a given value — has never existed natively in Google Sheets. Until now. SheetTrace brings Excel-style formula auditing directly into Google Sheets. With a single keyboard shortcut, you can trace all the cells that feed into any formula (Trace Precedents) or find every cell in your spreadsheet that references a given cell (Trace Dependents). Navigate between dependent cells in seconds, jump back to where you started with one key, and audit even the most complex multi-sheet workbooks with ease. SheetTrace works entirely within Google Sheets — no switching tabs, no external tools, no disruption to your workflow. This is the tool that every serious Google Sheets user has been waiting for. WHY FORMULA AUDITING MATTERS Spreadsheets are only as trustworthy as the formulas inside them. In financial modeling, a single broken reference can cascade into errors that affect an entire model — budgets, forecasts, valuations, and reports. In data analysis, knowing which cells contribute to a calculated result is essential for debugging, for peer review, and for building reliable pipelines. In accounting, tracing where a number came from is not just useful — it is required. For years, Excel users have relied on its built-in Trace Precedents and Trace Dependents arrows to audit formulas visually. These tools make it possible to answer the two most important questions in spreadsheet work: Where does this formula get its data from? What else in this workbook depends on the value in this cell? Google Sheets has never had an answer to either question. Spreadsheet power users who moved from Excel to Google Sheets have had to manually trace references by reading formulas, searching cell by cell, or maintaining separate documentation just to understand the structure of their own workbooks. SheetTrace solves both problems instantly, with keyboard shortcuts designed to feel native to Google Sheets. CORE FEATURES ▶ TRACE PRECEDENTS — Ctrl + [ Press Ctrl + [ on any cell that contains a formula, and SheetTrace instantly extracts every cell reference from that formula and presents them in a clean, keyboard-navigable popup. Use the arrow keys to move through the list and press Enter to jump directly to any precedent cell. The popup handles all reference types: simple A1-style references, absolute references with dollar signs ($A$1), named ranges, cross-sheet references (Sheet2!B4), and even range references that span multiple cells (A1:D10). Trace Precedents is invaluable when you are auditing a formula and need to see all its inputs at once. Instead of reading the formula bar and mentally parsing each reference, SheetTrace gives you a clean list you can act on immediately. Jump to any input cell, inspect it, then press F5 to return to where you started — no manual navigation, no losing your place. ▶ TRACE DEPENDENTS — Ctrl + ] Press Ctrl + ] on any cell — whether it contains a formula, a value, or a constant — and SheetTrace searches your entire workbook to find every formula that references that cell. Results appear in the same clean popup, sorted by sheet. Use the arrow keys to move through dependents and press Enter to navigate to any of them directly. Trace Dependents searches across every sheet in your workbook simultaneously. It correctly identifies references even when they use absolute addressing ($B$4), when the active cell is part of a referenced range (like A1:A100 which includes A50), and when formulas reference the cell by its full cross-sheet address. The search is exhaustive — every formula in every cell of every sheet is checked, so you will never miss a dependent. This feature is powered by the Google Sheets API v4, which means it reads your spreadsheet data securely and accurately, handling workbooks of any size. SheetTrace requests only the minimum data it needs — formula values only, not cell formatting or display values — keeping the lookup fast even on large spreadsheets. ▶ F5 RETURN NAVIGATION Every time you use Trace Precedents or Trace Dependents to jump to another cell, SheetTrace saves your starting position automatically. Press F5 at any time to return instantly to the cell you were auditing before you jumped. This creates a simple, intuitive audit workflow: trace a reference, inspect the target cell, press F5 to return, move on to the next reference. No bookmarking, no manual navigation, no losing your place in a complex formula. The F5 return shortcut is designed to mirror the familiar workflow from Excel, where auditors routinely jump between precedents and dependents and need a reliable way to navigate back. In SheetTrace, it just works. ▶ KEYBOARD-DRIVEN POPUP NAVIGATION The SheetTrace popup is designed for keyboard-first operation. Every interaction can be completed without touching the mouse: Arrow Up / Arrow Down: Move through the list of references Enter: Navigate to the selected cell Escape: Close the popup and stay where you are F5: Return to the origin cell (works even after the popup is closed) The popup appears at the top of your screen, clear of the formula bar and cell grid, so you can see the list and the spreadsheet simultaneously. It is styled to match the Google Sheets UI — clean white background, Google Sans font, the familiar Google blue highlight — so it feels like a native part of the application rather than a foreign overlay. WHO SHEETTRACE IS FOR SheetTrace is built for anyone who works seriously with Google Sheets. It is especially valuable for: Financial Analysts and Modelers — Large financial models in Google Sheets can contain hundreds of interconnected cells spread across dozens of sheets. Auditing the logic of a DCF model, a…