How can I jump to a referenced cell?

let’s say I’m at Sheet1 cell A1. This cell takes the value of Sheet2, cell B2. Is it possible for me to go to Sheet 1, cell A1 and ‘jump’ to Sheet2, cell B2 automatically? If not, is there anyway that I could create a function that would allow me to do that? I know in Excel, I could write a VBA program to do that (although I’d rather not).


Use the following hotkeys to jump to the reference cell (from cell $Sheet1.A1 to cell $Sheet1.B2) :

CTRL + [

note : the same hotkey works in excel.

I believe you actually mean:

(from cell $Sheet1.A1 to cell $Sheet2.B2)