Tracing Precedents

Contact Us or call 1-877-932-8228
Tracing Precedents

Tracing Precedents

Tracing precedents in Microsoft Excel allows you to visually see which cells impact a given cell. To trace precedents:

  1. Select the cell to trace precedents for.
  2. On the FORMULAS tab, in the Formula Auditing group, click the Trace Precedents command:Trace Precedents
  3. The following screen shot shows the precedents for cell B11:Precedents
  4. By clicking Trace Precedents a second time, we see another level of precedents (the precedents for the cells directly preceding the first cell):Trace Precedents
  5. Clicking Trace Precedents subsequent times shows additional levels of precedents. If one of the preceding cells is on another sheet, Excel will add an arrow pointing to an image of another sheet:Arrow
  6. By double-clicking the small circle next to the image of the sheet, you can open the Go To dialog box to see which sheet the cell refers to:Go To Dialog Box
  7. Select the sheet and click OK to go to the specific cell in the other sheet:Sheet
  8. To remove the arrows showing precedents, click Remove Arrows:Remove Arrows
Next