debugging worksheet find inheritance parent of cell in Excel
Q105. In Excel, how can I identify the cells that influence a particular cell to help with debugging of my Spreadsheet or understand a Spreadsheet that I inherited?
For example, I have inherited a complex WorkBook. I want to understand how value has been arrived at for a particular cell with formula - essentially I want to understand the cells that influence the value of the cell of interest.
In the example below, I want to the identify the precedent cells that determine the value of cell of interest, B9.
To do it in Excel, here is the answer:
a) Select the cell of interest ("B9" in this case). Click on "Trace Precedents" under "Formulas".
b) All the cells that influence the cell of interest are connected by arrows. This can help analyze how value is determined for the cell of interest.
c) To remove the arrows, Click on "Remove Arrows" under "Formulas". Click on "Remove Precedent Arrows".
d) All the "Precedent Arrows" would be removed as shown below.