I'm not sure if this information is actually redundant and everybody else knows about this, but I'm putting it here so that Iwouldn't have to look when I need it later. It regards the dependency check for certain formulas or cells.
Scenario:- In MS Excel, you have a cell (A1) with formula say "=A2 + A3"
Then you have another cell (B1) with the formula "=A1 + B2"
Then you have another cell (B3) with the formula "=A4 + B4"
And many other cells with different / various formulas.
Suddenly you realise a few days later, you forgot what A1 stands for and which other formulas
actually refer to the values contained in cell (A1), therefore, you will need the dependancy check.
Solution:- All you have to do is:-
1> Select cell A1
2> Select "Tools" form Menu -> Formula Auditing
3> Click on Trace Dependants
4> That's it, you will have the dependencies highligted with arrows.
5> You can remove the arrows by clikcing on "Remove All Arrows" instead of "Trace Dependants"
No comments:
Post a Comment