Can Google Sheets trace precedents like Excel?

Not natively — Google Sheets has no formula auditing feature. The XLKeys Chrome extension adds Trace Precedents (Ctrl + Shift + [) and Trace Dependents (Ctrl + Shift + ]) to Google Sheets.

Does trace precedents work across sheets?

Yes. XLKeys highlights precedents on the current sheet and flags references that live on other tabs so you can follow the chain through the whole workbook.

Is Trace Precedents free?

Trace Precedents is an XLKeys Pro feature. Pro comes with a 30-day free trial — no credit card required.

All shortcuts

Trace Precedents in Google Sheets

Pro

Windows

Ctrl+Shift+[

Mac

⌘+Shift+[

When you inherit a model, the first question about any formula is: where do these numbers come from? Excel answers with Trace Precedents. Google Sheets has nothing built in — you’re left reading formulas character by character.

XLKeys adds true formula auditing to Sheets. Select a formula cell, press Ctrl + Shift + [, and every input cell lights up — including precedents on other sheets. Step backwards through a model in seconds.

Excel vs. Google Sheets vs. XLKeys

Where	Shortcut
Excel	`Ctrl`+`[ (select precedents) / Trace Precedents arrows`
Google Sheets (native)	No keyboard shortcut
Google Sheets + XLKeys	`Ctrl`+`Shift`+`[`

Google Sheets has no formula auditing tools at all — no trace precedents, no trace dependents.

How to use it

Select a cell containing a formula.
Press Ctrl + Shift + [ (⌘ + Shift + [ on Mac).
Every cell the formula references is highlighted, on this sheet and others.
Use Alt → G → B to jump back to where you started.

Frequently asked questions

Related shortcuts

Trace Dependents

Ctrl+Shift+]

Goal Seek

Alt→A→W→G

Sensitivity Table (Data Table)

Alt→A→W→T

Make Google Sheets feel like Excel

Install XLKeys to use trace precedents and 150+ other Excel-style shortcuts, Alt-key sequences, formula auditing, Goal Seek, and Sensitivity Tables in Google Sheets.

Add XLKeys to Chrome Free printable cheat sheet →