Formula auditing toolbar

 

 The Formula Auditing Toolbar enables you to trace graphically the relationships between cells. It also allows you to monitor cell contents by placing them in a Watch Window.

 

    To display the formula auditing toolbar

        View > Toolbars > Formula auditing

     

    To trace a cell's precedents

  1. Select a cell containing a formula
  2. Click on the Trace Precedents button
  3. Click on the Trace Precedents button again to display the previous level of precedents.
  4. Remove tracer arrows one level at a time by clicking Remove Precedent Arrows
  5.  

    To trace a cell's dependents

  1. Select a cell containing a formula
  2. Click on the Trace Dependents button
  3. Click on the Trace Dependents button again to display the previous level of dependents.
  4. Remove tracer arrows one level at a time by clicking Remove Dependent Arrows
  5.         

    To select the cell at the other end of an arrow

    Double click the arrow

     

    To remove all tracer arrows

    Click the Remove All Arrows button.

     

    To display all the relationships in a worksheet

  1. In an empty cell, type =
  2. Then click the Select All button and evaluate the cell with Ctrl-Enter
  3. Click the Trace Precedents button twice.

     

    To display a formula in a cell

    Select the cell and press F2

     

    To display all formulae

    Click Ctrl-~

     

    To add a cell to the watch window

  1. Open the Watch Window by clicking on the Watch Window button in the Formula Auditing Toolbar.
  2. Select the cells you want to monitor.
  3. Click on the Add Watch button in the Watch Window.
  4.