1-866-245-5224 sales@keystonelearning.com

Excel 2007: Tracing Precedents

Excel 2007: Tracing Precedents

A precedent is a cell that is referenced by a formula in another cell. In our example (at right), the points of origin are the precedents.

Tracing Precedents Using the Ribbon

     
  1. Click any cell containing a formula
     
  2.  
  3.  Click the Trace Precedents command in the Formula Auditing group on the Formula tab
     

Removing Precedent Tracers

     
  1.  Click the Remove Arrows drop-down arrow in the Formula Auditing group on the Formula tab
     
  2.  
  3. Choose Remove Precedent Arrows