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

Chapter 5. Troubleshooting Formulas > Tracing Cell Precedents

Tracing Cell Precedents

To trace cell precedents, follow these steps:

1.
Select the cell containing the formula whose precedents you want to trace.

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

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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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