Select direct dependents

Sponsored Link

Windows shortcut†

Ctrl]

Mac shortcut†

‚ĆÉ]

This shortcut will select all cells with formulas that depend on the cells in the current selection. When you use this shortcut, Excel looks for formulas that refer to currently selected cells. If found, Excel selects the cells that contain these formulas.