Trace dependents
Trace direct dependents of multiple cells. Analyse large sheets and multi-sheet workbooks.
Understand downstream impact before making changes — open Dependents and find formulas that rely on your selection.
Press Alt + Q to launch analysis across all sheets. Select any single cell or group of cells, and watch as results arrive dynamically — grouped by sheet name and updated live as the analysis progresses. Select specific sheets to analyse and restart at any time with the restart button.
Navigate with the arrow keys: ← / → move in and out of sheets containing grouped dependent ranges, ↑ / ↓ navigate to each dependent range. Perfect for financial modelling and scenario analysis — quickly verify which calculations will be affected by changes to key inputs.
Works inside Google Sheets.
Features
Analyse
Multi-cell selection
Select any single cell or group of cells to view all direct formula-based dependents — a unique capability not available natively in Google Sheets.
Comprehensive range detection
Supports all reference types including individual cells (A1 or $B$2), cell ranges (A1:C10), column slices (M166:M), column ranges (A:C), row slices (M166:166), and row ranges (3:10).
Named ranges resolved
Named ranges are fully resolved, so dependencies are traced to their actual underlying cell references.
Organise
Grouped by sheet
Results are intelligently grouped by sheet name, keeping large workbooks easy to navigate.
Consolidated into logical blocks
Contiguous dependent cells are automatically consolidated into matrices, rows, columns, or individual cells.
Navigate
Keyboard‑driven navigation
Use ←, →, ↑, and ↓ to move quickly between dependent ranges.
Performance
Built for large workbooks
Designed for efficient analysis of very large sheets and multi-sheet workbooks.
Parallel analysis
Analysis runs in parallel, leveraging Google APIs and cloud infrastructure to avoid timeouts.
Graceful error handling
Errors are handled gracefully so partial results remain usable. Analysis can be restarted at any time with a manual selection of specific sheets.
Experience
Analyse all sheets by default
Analysis runs across all sheets by default — ideal for large, multi-sheet workbooks.
Keyboard‑first experience
Fast navigation with arrow keys — you rarely need the mouse.
Direct formula dependencies
Only direct formula-based dependents are identified. Dependencies created through INDIRECT, OFFSET, or other dynamic functions are not detected.
Works inside Google Sheets.