Checking formulas because that accuracy or recognize the resource of one error may be challenging if formula uses precedent or dependent cells:
Precedent cell — cells that are referred to by a formula in another cell. Because that example, if cabinet D10 has the formula =B5, climate cell B5 is a precedent to cell D10.
You are watching: How do you activate range finder to verify a formula in a cell?
Dependent cells — these cells save formulas that refer to various other cells. For example, if cell D10 has the formula =B5, cell D10 is a dependency of cabinet B5.
To assist you in checking her formulas, you deserve to use the Trace Precedents and also Trace Dependents regulates to graphically display and trace the relationships in between these cells and also formulas v tracer arrows, as shown in this figure.
Follow these actions to display formula relationships amongst cells:
Click file > Options > Advanced.
Note: If you space using Excel 2007; click the stclairdrake.net Office switch
In the Display alternatives for this workbook section, select the workbook and then inspect that All is preferred in For objects, show.
To specify recommendation cells in an additional workbook, the workbook need to be open. Stclairdrake.net Office Excel cannot walk to a cell in a workbook that is no open.
Do one of the following.
Trace cells that carry out data to a formula (precedents)
Follow these steps:
Select the cabinet that consists of the formula because that which you desire to find criterion cells.
To display a tracer arrowhead to each cell that directly provides data to the energetic cell, top top the Formulas tab, in the Formula Auditing group, click Trace Precedents .
Blue arrows present cells with no errors. Red arrows show cells that cause errors. If the selected cell is referenced through a cell on an additional worksheet or workbook, a black arrowhead points indigenous the selected cabinet to a worksheet icon . The various other workbook need to be open before Excel can trace these dependencies.
To determine the following level of cell that provide data come the active cell, click Trace Precedents again.
To remove tracer arrows one level at a time, begin with the precedent cell furthest far from the active cell. Then, ~ above the Formulas tab, in the Formula Auditing group, click the arrowhead next to Remove Arrows, and also then click Remove precedent Arrows
Follow this steps:
Select the cell because that which you want to recognize the dependence cells.
To display a tracer arrowhead to each cell the is dependence on the energetic cell, on the Formulas tab, in the Formula Auditing group, click Trace Dependents .
Blue arrows show cells v no errors. Red arrows present cells that reason errors. If the selected cell is referenced by a cabinet on another worksheet or workbook, a black arrow points indigenous the selected cell to a worksheet icon . The other workbook need to be open prior to Excel deserve to trace these dependencies.
To recognize the next level of cells that count on the active cell, click Trace Dependents again.
To remove tracer arrows one level in ~ a time, starting with the dependent cell farthest away from the active cell, top top the Formulas tab, in the Formula Auditing group, click the arrowhead next to Remove Arrows, and also then click Remove dependency Arrows
Follow these steps:
In an empty cell, enter = (the equal sign).
Click the pick All button.
Select the cell, and on the Formulas tab, in the Formula Auditing group, click Trace Precedents twice
To eliminate all tracer arrows on the worksheet, on the Formulas tab, in the Formula Auditing group, click Remove Arrows
Issue: stclairdrake.net Excel beeps when I click the map Dependents or trace Precedents command.
If Excel beeps as soon as you click Trace Dependents or Trace Precedents , Excel has actually either traced all levels the the formula, or you room attempting to trace things that is untraceable. The following items top top worksheets that can be referenced through formulas space not traceable making use of the auditing tools:
References to text boxes, installed charts, or images on worksheets.
References to called constants.
Formulas situated in an additional workbook that refer to the energetic cell if the other workbook is closed.
To check out the color-coded precedents because that the arguments in a formula, pick a cell and also press F2.
To choose the cell at the other finish of one arrow, double-click the arrow. If the cabinet is in one more worksheet or workbook, double-click the black arrowhead to display the Go To dialog box, and also then double-click the referral you want in the Go to list.
See more: Explain What The Product Of A Multiplication Sentence Is, Multiplication
All tracer arrows disappear if you change the formula to which the arrows point, insert or delete columns or rows, or delete or relocate cells. To regain the tracer arrows ~ making any of these changes, you should use auditing commands on the worksheet again. To keep track of the initial tracer arrows, publish the worksheet through the tracer arrows displayed before you make the changes.