show precedents

J

Joe B

Is there a way of listing or showing all the precedent
cells related to a particular cell other than using
the 'trace precedents' tool (including those on different
worksheets and workbooks)? I would like to use this to
identify precedents for a particular value and then
follow a change made in a precendent cell to all
dependents downstream. Thanks!

Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top