Apologies if this is answered
Hi all, I want to find a way to get a list with ALL the cells which a cell value (D1) depends on. I know about the Trace Precedents tool, but it will only show cells which are in cell D1's formula, and I want to avoid doing lots of Trace Precedents for each previous cell.
So if I have a cell D1, which depends on C1, which depends on B1, which depends on A1. But if I use trace precedents, it will only show me C1. However if A1 or B1 change, D1 will also change. Is there a quick way to display a list with all the cells that D1 is a function of?
Thanks.
Bookmarks