Also read: How to use Goal Seek feature in Excel 2013
Precedents are cells or ranges of cells that affect the active cell value.
Dependents are cell or ranges of cells that are affective by the active cell.
Dependents are cell or ranges of cells that are affective by the active cell.
Trace Precedents and Trace Dependents are powerful tools under Formula Auditing in Excel. Go to: "FORMULAS" tab in the ribbon>>>Functions under Formula Auditing [Alt+M]
- Trace Precedents [Alt+MP]: When we click this button when the active cell contains formula, it draws arrows from the primary cells which are directly affecting the formula in the active cells (direct precedents). On clicking the button once again, it shows more arrows from cells which are affecting direct precedent cells and so on.
- Trace Dependents [Alt+MD]: When we click this button, it draws arrows from the selected cell to the cells (direct dependents) that use, or depend on, the results of the formula in the selected cell. On clicking the button once again, it shows "tracer" arrows identifying the cells (indirect dependents) that refer to formulas found in the direct dependents.
- Remove Arrows [Alt+MA]: On clicking this button, all the arrows created by precedents and dependents are removed. Additionally, Excel also gives options of customized removal of arrows by providing two buttons in the drop-down besides Remove Arrows.
- Remove Precedent Arrows [Shortcut: Alt+MAP] - Removes only precedent arrows
- Remove Dependent Arrows [Shortcut: Alt+MAD] - Removes only dependent arrows
IMPORTANT NOTES:
- Double-clicking an arrow activates the cell on one end of the line. Double-clicking again activates the cell on the other end.
- If the relationship shown by arrows are in the same worksheet, then Excel draws red or blue arrows. It shows black dotted arrow with miniature icon of worksheet in case the relationship exists with another worksheet (in same or different workbook).
More interesting articles on this website:
No comments:
Post a Comment