Home » Budget Spreadsheet » Issue Tracking Spreadsheet Template Excel
Issue Tracking Spreadsheet Template Excel

Issue Tracking Spreadsheet Template Excel

Issue Tracking Spreadsheet Template Excel – Testing formulas to determine precision and find the source of an error is difficult when the formula uses precedent or dependent cells: To help, use Track Dependents and Track Precedents to graphically display the relationships between cells and Formulas with tracking arrows.

Dependent cells contain formulas that refer to other cells.
For example, if cell D10 contains the formula = B5, cell D10 depends on cell B5.

Previous cells are one at a time that the formula of another cell refers to.
For example, if cell D10 contains the formula = B5, cell B5 is precedent of cell D10.

Trace cells that refer to another cell (dependent)

  1. Select the cell from which you want to identify the dependent cells.
  2. On the Formulas tab, select Track Dependents to display a tracking arrow in each cell that depends on the active cell.
    Track Previous
  3. Blue arrows: display cells without errors.
  4. Red arrows: cells that cause errors.
  5. Black arrows: If another worksheet or other workbook refers to the selected cell, an arrow the black lady in the cell selected the icon in a Worksheet worksheet. The other workbook must be open so Excel can track these dependencies.
  6. Select Trace Dependents again to identify the level of the cells that depend on the active cell.
  7. NOTE: At some point, you will hear a beep, otherwise the arrows will stop appearing.
  8. To remove the arrows from the tracking arrows by the levels, starting with the dependent cell closest to the active cell, select the arrow next to Remove arrows on the Formulas tab, and then select Remove a level of dependents.
  9. For another level of tracking arrows, select Remove a level of dependents again.

Trace cells that provide data to a formula (precedents)

  1. Select the cell from which you want to identify the preceding cells.
  2. Select Formulas> Track precedents to display a tracking arrow in each cell that directly provides data to the active cell.
    Track Previous
  3. Blue arrows: display cells without errors.
  4. Red arrows: display cells that cause errors.
  5. Black arrows: If another worksheet or other workbook refers to the selected cell, a black arrow points from the selected cell to a Worksheet spreadsheet icon. The other workbook must be open so Excel can track these dependencies.
  6. Select Trace Precedents again to identify the next level of the cells that provide data for the active cell.
  7. NOTE: At some point, you will hear a beep, otherwise the arrows will stop appearing.
  8. To remove the arrows from the level tracking arrows, starting with the previous cell closest to the active cell, select the arrow next to Remove arrows on the Formulas tab, and then select Remove a level of precedents.
  9. To remove another level of tracking arrows, select again Remove a level of precedents.

Issue Tracking Spreadsheet Template Excel