Trace cell references

[2 minutes total]

Excel spreadsheets often contain a number of calculations and it is easy to lose track of which data are feeding into a particular calculated cell. These two tutorials show how to visually display the data items that are being used in particular calculated cell values.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

• Activating trace cell references to determine all cells that reference to a single cell (1:00)
• Activating trace cell references to determine all cells to which a single cell references (1:16)

You may need to turn off your browser's pop-up blocker or install the latest Flash plug-in to view these tutorials.