If Excel is not highlighting cells in the formula, place the cursor in the cell containing the formula and press fn+f2. This should highlight all the cell references.

We explain how to fix the issue when Excel is not auto-calculating formulas. Excel is an advanced tool when calculating formulas for statistics.