• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Troubleshooting Formulas > Tracing Cell Dependents

Tracing Cell Dependents

Here are the steps to follow to trace cell dependents:

1.
Select the cell whose dependents you want to trace.

2.
Choose Tools, Formula Auditing, Trace Dependents, or click the Trace Dependents toolbar button. Excel adds a tracer arrow to each direct dependent.

3.
Keep repeating step 2 to see more levels of dependents.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint