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.

excel debugging worksheet find inheritance parent of cell

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".

excel excel debugging worksheet find inheritance parent of cell

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.

excel excel excel debugging worksheet find inheritance parent of cell

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

excel excel excel excel debugging worksheet find inheritance parent of cell

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

excel excel excel excel excel debugging worksheet find inheritance parent of cell

 

You can find similar Excel Questions and Answer hereunder

1) How to change the color of gridlines in a worksheet in Excel

2) How can I enter multiple lines of data in a cell?

3) How to read a value from a cell in vba in Excel

4) 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?

5) Can I add a small chart to Table data to make it visually appealing and easy to interpret?

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

7) How can I identify all cells with Data Validation in my WorkSheet?

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

9) How can I add a background image to a worksheet?

10) how do you enter multiple line in a cell in Excel

11) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?

12) How can I quickly navigate to a frequently used field in a voluminous worbook?

13) Highlight row of selected cell in Excel

14) How can I hide a specific Shape in my WorkSheet?

15) I want to add a trend indicator symbol next to my sales data - how can I do that?