See all cells referencing a certain cell

[joedrummer]

Is there any way to see all the cells that are referencing a certain cell.
i.e. If A1 is a percentage and I want to see all other cells that are referencing that percentage.

[Leith Ross]

Hello joedrummer,

Select the cell with the formula you are interested in. On the main menu select Tools > Formula Auditing > Trace Precedents. Arrows will appear showing the other cells that used in the formula.

Sincerely,
Leith Ross