When you're working on a worksheet that contains formulas, there is an easy way to quickly navigate through all the cells referenced in a formula: Highlight the cell that contains the formula and press Ctrl-[ (Ctrl and the open square bracket). Excel will then highlight all the cells referenced by the formula, and moves the current selection to the first of the referenced cells.This also makes it very simple to navigate through all of the referenced cells; if you press Enter, and the selection moves to the next one, and you can continue to press Enter to move though the rest of the referenced cells. In this screenshot, I started out in cell D35 and pressed Ctrl-[. This highlighted D12, D26, and D35, and made D12 the current cell.
