Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community
SOLVED

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.
Tom
1 best response

Accepted Solutions