Tracing in Excel

Excel allows you to trace precedents, dependents, and errors. For example to trace precedents or in other words to trace the linked cells to the summed or calculated cell, follow these steps:

Notice that there are other traces such as Dependents for tracing the dependency of cells that contain formulas, or Trace Error that will help in troubleshooting errored cells. Of course, you can also use this tip to make diagrams by using more than one Trace Precedent cell. For example just try putting an =sum(A7+C7) in cell B7 and then select Tools, Auditing, Trace Precedents and you will have an arrow. Experiment, it can be fun.
home button   Just click on the button for the Tiproom's Home Page.