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.
I work as a financial analyst and your page is a leading one I use to find so important info for daily tasks like formula explanation, how to construct different formulas and so on. This is brilliant! You helped me a lot. - Sarunas
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course