How to Select all dependents?
Excel provides you with a shortcut to select all dependents
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.
- Select any cell from Date column. In this case, it is C7.
- Press the shortcut keys i.e. Ctrl+Shift+}
- Cell E7 gets highlighted.
Figure 2. Example 1 of Select all dependents