Exceljet

Quick, clean, and to the point

Select direct dependents

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.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.

How to trace formula relationships

In this video, we'll look at how to quickly find formulas and trace how they are related to one another, using the concept of precedents and dependents.

form.antibot { display: none !important; } You must have JavaScript enabled to use this form.

Just like to say, your tutorial “INDEX and MATCH with multiple criteria” completely rocks. A colleague tried to teach me this a while ago and I couldn’t get it; a few years more experienced now, I needed this function today and nailed it on the first go after reading your article. -Shelley

Select direct dependents

Related videos

Download 200+ Excel Shortcuts

Excel video training