Forum Discussion
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.
Did you try this Display the relationships between formulas and cells - Microsoft Support functionality?
4 Replies
- Detlef_LewinSilver Contributor
- SamBarroCopper ContributorSergei and Detlef, excellent! Thanks very much.
Tom- SergeiBaklanDiamond Contributor
SamBarro , you are welcome
- SergeiBaklanDiamond Contributor
Did you try this Display the relationships between formulas and cells - Microsoft Support functionality?