There is a way to change a setting in Excel that might make it easier for you to review formulas by being able to go directly to the cells referenced in the formula.
In Excel, the default setting allows you to edit a formula when you double click on that formula.
However, you may not realize you have the option to modify the setting and change how you can navigate in Excel. Go to the Tools menu, select Options, then click the Edit tab.
The first option listed is called Edit Directly in Cell. Unclick that and you now pick up some new navigation functionality in Excel. Now when you double click on a cell in a formula, you go to the cells in the formula. For example on these formulas:
+B4. Double click and you go to cell B4.
=sum(B2:B10). Double click and you go to the entire range that is summed.
=IF(B5>1,+B3,+B2). Double click and you go to each cell in the formula, even though it is a non-continuous range.
You might find this very handy for reviewing formulas.
Of course, you have made a tradeoff. You then can't edit a formula by double clicking on the formula. However, when you are in the cell and have not double clicked on it, the formula still appears in the formula bar, so you can edit it from there.
If you like the navigation feature, you might decide to just use it in special situations. By going back to Tools, then Options, you can easily switch this on or off.
If you do not ever turn off this default setting, you still do get to see the cells referenced in a formula when you double click on them- Excel will highlight them. The difference is that you are not taken directly to the referenced cells. In the default setting, you are still in the cell with the formula.
So it is a matter of personal preference. We suggest trying it both ways and use what works best for you, depending on the situation.