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

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Topics

Key functions

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Read more.

Just wanted to give a HUGE thank you for all of your content. I was NOT proficient at Excel, even though my resume clearly says differently ;), until I found this website. Now, I've become the "Excel Guy" at my company and I owe 90%-ish to ExcelJet. I have yet to find another website that gives clear, concise, and in-depth explanations like you do. KEEP UP THE GREAT WORK! -James

Exceljet

Quick, clean, and to the point

Select direct dependents

Related videos

Download 200+ Excel Shortcuts

Excel video training