SheetSpeedIn Excel, Ctrl+[ jumps to a formula's inputs and Formulas → Trace Precedents draws arrows to them. Google Sheets has neither. When you inherit a model, that makes checking a formula slow.
Blog · 2026-10-16
How to Trace Precedents in Google Sheets (Free, Keyboard-Only)
Trace precedents is the Excel auditing feature analysts miss most in Sheets. Here's how to get it back for free.
What Sheets gives you natively
- Click into a formula (or press F2) and Sheets outlines each referenced range in color.
- Ctrl+~ shows all formulas on the sheet.
Both help, but neither lets you list the inputs and walk through them from the keyboard, especially when they're on other tabs.
Trace precedents with SheetSpeed (free Core)
- Install SheetSpeed from the Chrome Web Store.
- Select a cell with a formula.
- Press Ctrl+Shift+[.
A panel lists every reference in the formula. Then:
- ↑ / ↓ moves through the precedents and jumps to each one.
- Enter drills into a precedent that is itself a formula, without closing the panel.
- F5 returns you to the original cell.
It works by reading the formula on screen, locally in your browser. It doesn't ask for Google API access to your spreadsheet.
Trace dependents
The reverse question, "what uses this cell?", is harder: answering it means scanning the workbook. SheetSpeed Pro (launching soon) adds Ctrl+Shift+] as a bounded, cancelable scan that tells you if it stopped before covering everything. Other extensions, including SheetWhiz, XLKeys and ShortieCuts, also offer trace dependents in paid tiers.
Tips for auditing a model in Sheets
- Start from the output and trace backwards with Ctrl+Shift+[ and Enter.
- Use F5 to get back when you've gone deep.
- Pair tracing with a consistent color convention (blue inputs, black formulas) so hardcodes jump out.
SheetSpeed is a free Chrome extension for Excel-style shortcuts and trace precedents in Google Sheets. We make it, so weigh our take accordingly.