Find dependents cells in excel very easily bu clicking on the cell you want to trace and then go to the formula tab in excel and clicking on Trace Precedents.
Trace precedents in Excel 2019 will
Display the relationships between formulas and cells
Checking formulas for accuracy or finding the source of an error may be difficult if formula uses precedent or dependent cells:
Precedent cells — cells that are referred to by a formula in another cell. For example, if cell D10 contains the formula =B5, then cell B5 is a precedent to cell D10.
Dependent cells — these cells contain formulas that refer to other cells. For example, if cell D10 contains the formula =B5, cell D10 is a dependent of cell B5.
To assist you in checking your formulas, you can use the Trace Precedents and Trace Dependents commands to graphically display and trace the relationships between these cells and formulas with tracer arrows, as shown in this figure.
Worksheet with tracer arrows
Follow these steps to display formula relationships among cells:
Click File - Options - Advanced.
Note: If you are using Excel 2007; click the Microsoft Office Button Office button image , click Excel Options, and then click the Advanced category.
In the Display options for this workbook section, select the workbook and then check that All is chosen in For objects, show.
To specify reference cells in another workbook, that workbook must be open. Microsoft Office Excel cannot go to a cell in a workbook that is not open.
Trace cells that provide data to a formula (precedents)
Follow these steps:
Select the cell that contains the formula for which you want to find precedent cells.
To display a tracer arrow to each cell that directly provides data to the active cell, on the Formulas tab, in the Formula Auditing group, click Trace Precedents Button image .
Blue arrows show cells with no errors. Red arrows show cells that cause errors. If the selected cell is referenced by a cell on another worksheet or workbook, a black arrow points from the selected cell to a worksheet icon Worksheet icon . The other workbook must be open before Excel can trace these dependencies.
To identify the next level of cells that provide data to the active cell, click Trace Precedents Button image again.
To remove tracer arrows one level at a time, begin with the precedent cell furthest away from the active cell. Then, on the Formulas tab, in the Formula Auditing group, click the arrow next to Remove Arrows, and then click Remove Precedent Arrows Button image . To remove another level of tracer arrows, click the button again.
Trace formulas that reference a particular cell (dependents)
Follow these steps:
Select the cell for which you want to identify the dependent cells.
To display a tracer arrow to each cell that is dependent on the active cell, on the Formulas tab, in the Formula Auditing group, click Trace Dependents Button image .
Blue arrows show cells with no errors. Red arrows show cells that cause errors. If the selected cell is referenced by a cell on another worksheet or workbook, a black arrow points from the selected cell to a worksheet icon Worksheet icon . The other workbook must be open before Excel can trace these dependencies.
To identify the next level of cells that depend on the active cell, click Trace Dependents Button image again.
To remove tracer arrows one level at a time, starting with the dependent cell farthest away from the active cell, on the Formulas tab, in the Formula Auditing group, click the arrow next to Remove Arrows, and then click Remove Dependent Arrows Button image . To remove another level of tracer arrows, click the button again.
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel
• 10 Most Used Formulas MS Excel
Learn Basic Excel Skills For Beginners || Part 1
• Learn Basic Excel Skills For Beginners || ...
10 Most Used Excel Formula
• 10 Most Used Excel Formula ☑️
*Most Imporant Excel Formuls Tutorials*
Learn Vlookup Formula For Beginners in Excel
• Learn Vlookup Formula For Beginners in Excel
5 Excel Questions Asked in Job Interviews
• 5 Excel Questions Asked in Job Interviews ☑️
Create Speedometer Chart In Excel
• Create Speedometer Chart In Excel
Learn the Basic of Excel for Beginners || Part 2
• Learn the Basic of Excel for Beginners || ...
Create Pareto Chart In Excel
• Create Pareto Chart In Excel
How to Create Dashboard in Excel
• How to Create Dashboard in Excel ☑️
Excel Interview Questions & Answers
• Excel Interview Questions & Answers ☑️
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788
Connect with us on Facebook - / excelmadeasy
Connect with us on Twitter - / excelmadeasy
Информация по комментариям в разработке