SOLVED

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

Copper Contributor

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

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)
Solution

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

Sergei and Detlef, excellent! Thanks very much.
Tom

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

@Tom_Tonon , you are welcome

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution