• 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 Formula References (Pre...

Checking for Formula References (Precedents)

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

Click the cell you want to trace (this cell must contain a formula) and click the Trace Precedents button. Excel draws tracer arrows to the appropriate cells.

Click the Trace Precedents button again to see if there are any precedents for these calculations.

If additional precedents are present, Excel draws additional tracer arrows to the appropriate cells.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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