Exceljet

Quick, clean, and to the point

Select all dependents

Windows shortcut 
CtrlShift}
Mac shortcut 
}

This shortcut will select all cells with formulas that refer directly or indirectly to cells in the current selection.

Related videos

Tip: How to trace formula relationships
In this video, we look at how to quickly find formulas and trace relationships, using the concept of precedents and dependents. A great way to quickly understand an unfamiliar worksheet.