Ctrl + [ will take you to the cell which is referenced first in the formula...

For example
A1+Sheet2!A1+Sheet3!A1 --- will take you to the same sheet A1
Sheet2!A1+Sheet3!A1+A1 --- will take you to sheet2 A1
Sheet3!A1+Sheet2!A1+A1 --- will take you to sheet3 A1

If this post helps click Yes
---------------
Jacob Skaria


"Sozos" wrote:

When I select a cell containing a formula which includes cells from different
worsheets and press ctrl [ I am not taken to the specefic cell. How do I
activate this shortcut?