Translate formulas to values    
 

This tool allows you to view formulas, but no longer with each cell's address, but rather with the value of each cell comprising the formula.

An example will provide a better explanation of the tool's function.
Let us use the following table:

 
 

We click on the Formulas to Values option of the dialog box and then we move through our worksheet's cells.

Notice how the formula's cells have been translated to their corresponding values.

 
 
Have another look,
 
 
Plus, as you may have already noticed, the tool shows the origin of the cells comprising the formula contained in the active cell.
Interesting, right?, use it!