Ask Your Question
0

How can I jump to a referenced cell?

asked 2019-02-26 14:18:30 +0200

NewbieNewb gravatar image

Hi, 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).

Thanks! NN

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2020-02-25 19:16:15 +0200

cupshaker gravatar image

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.

edit flag offensive delete link more

Comments

I believe you actually mean:

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

 :)
Ratslinger gravatar imageRatslinger ( 2020-02-26 06:12:44 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-02-26 14:18:30 +0200

Seen: 132 times

Last updated: Feb 25