All shortcuts

Trace Dependents in Google Sheets

Pro

Windows

Ctrl+Shift+]

Mac

+Shift+]

Before you change or delete a cell, you need to know what breaks downstream. Excel’s Trace Dependents answers that. Google Sheets gives you no way to ask the question.

With XLKeys, select any cell and press Ctrl + Shift + ] — every formula that references it is highlighted instantly, so you can edit with confidence instead of crossing your fingers.

Excel vs. Google Sheets vs. XLKeys

WhereShortcut
ExcelCtrl+] (select dependents) / Trace Dependents arrows
Google Sheets (native)No keyboard shortcut
Google Sheets + XLKeysCtrl+Shift+]

Google Sheets cannot show you which formulas depend on a cell — there is no native auditing tool.

How to use it

  1. Select the cell you’re about to change.
  2. Press Ctrl + Shift + ] (⌘ + Shift + ] on Mac).
  3. Every formula that depends on the cell is highlighted.
  4. Use Alt → G → B to jump back to your starting cell.

Frequently asked questions

Related shortcuts

Make Google Sheets feel like Excel

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