Select all dependents

How to Select all dependents?

Excel provides you with a shortcut to select all dependents

Windows Shortcut

Ctrl+Shift+}

MAC Shortcut

⌃+⇧+}

What does select all precedents shortcut do?

When you select a cell and apply this shortcut, all the formulas directly or indirectly related to that cell gets highlighted.

How to use the Shortcut to Select all Dependents?

Figure 1. Example 1 of Select all dependents

In this example, you have a small table. Our purpose is to see which formulas are related to a particular cell.

  1. Select any cell from Date column. In this case, it is C7.
  2. Press the shortcut keys i.e. Ctrl+Shift+}
  3. Cell E7 gets highlighted.

Figure 2. Example 1 of Select all dependents

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar