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

Part 5. Working with Formulas and Functi... > Checking for Cell References (Depend...

Checking for Cell References (Dependents)

Open the Tools menu, choose Formula Auditing, and select Show Formula Auditing Toolbar.

Click the cell you want to trace. This cell must not contain a formula.

Click the Trace Dependents button until the tracer arrows stop adding on to the appropriate cells.

Click the Remove Dependents Arrows button enough times to remove all the arrows (or click the Remove All Arrows button).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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