Using the Select All Dependents Shortcut
Windows keyboard shortcut
Mac keyboard shortcut
This Excel shortcut selects all cells with formulas that refer directly or indirectly to cells in the current selection. You must first select a formula before using this shortcut.
Other useful Select Special keyboard shortcuts