How can I see all cells that reference a given cell?

Copper Contributor

Is there a way to see all the cells in a sheet or workbook that refer to a given cell?  


Example: Let's say cell B references cell A, meaning the value of A is placed in B.  And let's say many other cells reference cell A.  Can I click on cell A and perform an operation that will display all the other cells that reference it?


This would be very useful because many times I want to make a change in cell A, but I don't know what effect that would have on calculations made with all the other cells that are using the value in cell A.  


Many thanks.

4 Replies
best response confirmed by Hans Vogelaar (MVP)
Sergei and Detlef, excellent! Thanks very much.
1 best response

Accepted Solutions