Power Formula Auditing: The Power Tool for every Excel User

Precedents for a single cell
Excel’s “Trace Precedents” and “Trace Dependents” works only for one cell.
Figure 24. Trace Precedents work for one cell.
For example, in the above figure, 3 cells are selected (as indicated by the
green border around B7:D7). “Trace Precedents” show the arrows only for
one cell (B7).
Multi-Precedents for a block of cells
With Power Formula Auditing, we can select one or many cells for tracing
precedents. The function/button is called Multi-Precedents

---

Figure 25. Power Formula Audit Buttons
It is a powerful extension of the “Trace Precedents” button in Excel.
Using the same expense example, we can select B7:D7. One click of Multi-
Precedents will draw precedents arrows for all the selected cells, as shown in
the next figure.
"Multi-Precedents" works on 1 cell, a block of cells, and even an entire
worksheet. It helps to identify the important cells and their connections.
Figure 26. Multi-Precedents work for many selected cells