200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Select all dependents – Microsoft Excel shortcut

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.