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

[SamBarro]

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.

[#2 · Accepted solution]

@SamBarro 

Did you try this Display the relationships between formulas and cells - Microsoft Support functionality?

[#3]

@SamBarro 

Trace dependents

https://support.microsoft.com/en-us/office/display-the-relationships-between-formulas-and-cells-a59b...

Or maybe Inquire add in

https://www.google.com/search?q=inquire+add+in+excel

[#4]

Sergei and Detlef, excellent! Thanks very much.
Tom

[#5]

@SamBarro , you are welcome