How to use the SELECT ALL DEPENDENTS Keyboard Shortcut in Excel

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.

Discover 242 Excel Keyboard Shortcuts for Windows and Mac

Other useful Select Special keyboard shortcuts

Select Direct Precedents

Select All Precedents

Select Direct Dependents

Select Visible Cells Only

Select Current Array

Excel SELECT ALL DEPENDENTS Keyboard Shortcut

Using the Select All Dependents Shortcut