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

Excel in Practice

When inheriting workbooks from others, you can run trace precedents to view cells that reference other workbooks and worksheet cells. Auditing tools help show relationships of precedents and dependents. Notice Figures 6.25 and 6.26. Figure 6.25 shows auditing precedents from other worksheets or workbooks denoted by the icon and Figure 6.26 shows the relationships of one formula with references to other cells on the worksheet. If you inherit workbooks, this will help you understand the layout and logic.

Figure 6.25. Trace precedents with icons denoting formulas reference other worksheets.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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