I used to double click on a cell to reveal each cell that was involved in a formula, and the cells would be highlighted in different colors. As well, the formula would remain in the formula bar.

As of tonight, when I double click into a cell, excel highlights the first cell in the formula in one format, and the other cells in a different format (I think it kind of grays them out), and the formula bar switches to reveal the content of the first cell in the original formula. This is extremely difficult to see exactly which cells are functioning in what way in a formula.

Does anyone know how to get the old system back? Did I inadvertently change something?

Thanks!