Find dependent cell in worksheet in Excel

For example, I have inherited a complex WorkBook. I have to make a particular change - I want to analyze the impact of changing the particular cell on the rest of the WorkBook before actually making the change.

In the example below, I want to change the interval period for analysis to 2 years - I want to analyze what happens if I amend the formula in cell B9 as part of changing year interval.

excel find dependent cell in worksheet

To do it in Excel, here is the answer:

a) Select the cell of interest ("B9" in this case). Click on "Trace Dependents" under "Formulas".

excel find dependent cell in worksheet

b) All the cells that are dependent on the cell of interest are connected by arrows. This can help analyze the impact of change to cell of interest.

excel find dependent cell in worksheet

c) To remove the arrows, Click on "Remove Arrows" under "Formulas". Click on "Remove Dependent Arrows".

excel find dependent cell in worksheet

d) All the "Dependent Arrows" would be removed as shown below.

excel find dependent cell in worksheet

 

You can find similar Excel Questions and Answer hereunder

1) How can I get input from user through a prompt and assign user's input to a cell?

2) How to see to which cells a cell is connected or used by. How to see the dependents of a cell

3) Given a raw data Table, how can I find the value of a field for a specific value of another field?

4) How can I avoid updates to cell values during macro execution?

5) How can I identify all cells with Conditional Formatting in my WorkSheet?

6) What are worksheets events in VBA. Here we explain some of the main one like like activate or deactivate

7) Highlight row of selected cell in Excel

8) How can I find the least common multiple using Excel?

9) How can I enter a cent symbol in a cell?

10) Is there any way I can see more region of my WorkSheet?

 

Here the previous and next chapter