By default, Excel displays the results of formulas in the worksheet instead of showing the actual formulas. However, you can choose to have Excel display the formulas so you can see how they’re put together.
Click the Formulas tab.
Click the Show Formulas button.
Formulas are displayed in the worksheet and the columns widen to accommodate the formulas, if necessary.
If you display formulas and then select a cell that contains a formula, colored lines appear around cells that are referenced by the formula.
Click the Show Formulas button again to hide the formulas.
Formulas are no longer displayed and the columns return to their original sizes.