Formula Auditing
2. Try it:
Trace Precedents
Select Cell E29.
Go to
Formulas->Formula Auditing.
Click
Trace Precedents. You will see an arrow from
Cell E6 to Cell E29.
Click Trace Precedents again.
You
should see arrows in each Row that trace the formulas.
Click Trace Precedents a third time.
You will see a
call out to each variable in Cells B1, B2 and B3.
Please
click on Remove Arrows to take off the tracings.