When you have created a table with some calculations and cell references, you can, as already shown in tip 6, display the cells where formulas are stored.
However, the longer a formula is, the more strenuous it is to look for the cells specified there on the sheet and to find an error. Wouldn’t it be practical if the trace that led to the calculation could be displayed?
Select a cell in which Excel calculations were carried out, and then select in the register: “Formulas” / “Track to predecessor”
See fig. (Click to enlarge)
Here the arrows show you with which cell values the result in the marked cell came about.
If too many cell references have flowed into the result of a cell, it will of course become confusing again with all the arrows, but this tip can be quite helpful for smaller calculations.