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

Auditing a Workbook

To avoid bogus results from incorrect formulas, you can have Excel identify the cells that have supplied data for a formula. That way, you can easily see whether all the cells you wanted have been included in the calculation.

To trace the precedents for a formula:

1.
Select the cell or cells that contain the formulas (Figure 16.18).

Figure 16.18. Select the formula or formulas to trace.


2.
From the Tools menu, choose Formula Auditing, and then choose Trace Precedents from the Formula Auditing submenu. Arrows appear to show the cells that are included in the formula (Figure 16.19).

Figure 16.19. Arrows show the links between a formula and the cells that supplied the data for it.


3.
Choose Trace Precedents again to view an additional level of precedents, if one exists.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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