Page 366 - Excel 2013 All-in-One For Dummies

348 Formula Auditing
clicked the Trace Precedents button; and Remove Dependent Arrows to get rid of the arrows that were drawn when you clicked the Trace Dependents button.
✦ Show Formulas: To display all formulas in their cells in the worksheet instead of their calculated values — just like pressing Ctrl+` (tilde).
✦ Error Checking: When you click this button or click the Error Checking option on its drop-down menu, Excel displays the Error Checking
dialog box, which describes the nature of the error in the current cell, gives you help on it, and enables you to trace its precedents. Choose the Trace Error option from this button’s drop-down menu to attempt to locate the cell that contains the original formula that has an error. Choose the Circular References option from this button’s drop-down menu to display a continuation menu with a list of all the cell addresses containing circular references in the active worksheet — click a cell address on this menu to select the cell with a circular reference formula in the worksheet. (See Book III, Chapter 1 for more on circular refer- ences in formulas.)
✦ Evaluate Formula: Clicking this button opens the Evaluate Formula dialog box, where you can have Excel evaluate each part of the formula in the current cell. The Evaluate Formula feature can be quite useful in formulas that nest many functions within them.
✦ Watch Window: Clicking this button opens the Watch Window dialog box, which displays the workbook, sheet, cell location, range name, cur- rent value, and formula in any cells that you add to the watch list. To add a cell to the watch list, click the cell in the worksheet, click the Add Watch button in the Watch Window dialog box, and then click Add in the Add Watch dialog box that appears.
Clicking the Trace Precedents and Trace Dependents buttons in the Formula Auditing group of the Formulas tab on the Ribbon lets you see the relation- ship between a formula and the cells that directly and indirectly feed it, as well as those cells that directly and indirectly depend on its calculation. Excel establishes this relationship by drawing arrows from the precedent cells to the active cell and from the active cell to its dependent cells.
If these cells are on the same worksheet, Excel draws solid red or blue arrows extending from each of the precedent cells to the active cell and from the active cell to the dependent cells. If the cells are not located locally on the same worksheet (they may be on another sheet in the same workbook or even on a sheet in a different workbook), Excel draws a black dotted arrow. This arrow comes from or goes to an icon picturing a miniature worksheet that sits to one side, with the direction of the arrowheads indicating whether the cells on the other sheet feed the active formula or are fed by it.