Tom’s Tutorials For Excel: Going To the Precedent Cell with a Keyboard Shortcut
Here’s a cool tip for the keyboard shortcut
Ctrl+[ which takes you from the formula cell you are on, to the precedent cell (if there is one) of that formula.
In this first example, the active cell is C5 which displays what is in precedent cell G2.
Ctrl+[ takes you to cell G2.
It also works for going to a precedent cell on a different worksheet.
In this next example, active cell E3 on Sheet1 displays what is in cell A4 of Sheet3.
Ctrl+[ takes you to cell A4 of Sheet3.
This also works for going to the precedent cell of a different workbook. In this final example, active cell B3 on Sheet2 of Book1 displays what is in cell H6 on Sheet1 of Book2.
Ctrl+[ takes you to Book2 (which does not need to be open at the time — Excel will open it for you), Sheet1, cell H6.