200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Select all dependents

Gain control of all cells that are "dependents" of the one you have selected. Dependent cells are those that are affected by your active cell through a formula. This shortcut adds to your selection cells that are indirectly correlated through multiple formulas.

Ctrl Shift }

Control Shift }

Get more Reference tips and tricks

Subscribe to our email updates and get Reference tips direct to your inbox.