find dependent cell in worksheet in Excel

Q104. In Excel, how can I identify the cells that are dependent on a particular cell?

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 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 excel excel find dependent cell in worksheet

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

excel excel excel excel find dependent cell in worksheet

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

excel excel excel excel excel find dependent cell in worksheet

 

You can find similar Excel Questions and Answer hereunder

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

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

3) How can I insert a watermark in my Worksheet?

4) How can I set the fill color, font color and set number format of cell to date?

5) How can I create dependent drop down lists?

6) How can I copy and rename a WorkSheet using VBA?

7) Highlight row of selected cell in Excel

8) How can I add and link a Chart Title to a cell value?

9) How can I enter a text in a cell with subscript and superscript?

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

11) How can I loop through all WorkSheets and get their names using VBA?

12) How can I add a WorkSheet and name it as required using VBA?

13) Find and count instances of a character in a string in Excel

14) How can worksheet functions be accessed in VBA?

15) I am a construction Engineer. Considering a room with dimension, 14ft x 12ft can I find the side of the largest square tile which can tile the room?