Hyperlink within a Google Spreadsheet?

Question

I have a Google spreadsheet with many tabs. I would like to put a link in a cell on one tab that when clicked take me to another cell on another tab.

Is this possible?

w0lf · Answer 1 · 2012-04-03 14:34:09Z

up vote 3 down vote

I've discovered this hack, perhaps it helps:

open the target sheet, the one you want to link to
copy the browser URL (notice it's unique per Sheet)
go to the other sheet and select the cell where you want to place the link
enter the following value in the cell: =HYPERLINK("paste here the URL copied at step 2", "enter link text here")

answered Apr 3 '12 at 14:34

w0lf
524210

	This opens a new instance of the spreadsheet -- does not just move to the selected tab. – Greg Schmidt Dec 2 '12 at 19:55
	Have you verified that? That only happens when you click the big + on the bottom left, isn't? – Jacob Jan Tuinstra Dec 2 '12 at 20:22
	@GregSchmidt yes, you are right. I see no way of avoiding that; all links in the spreadsheet open in another tab. – w0lf Dec 3 '12 at 10:09
	@JacobJanTuinstra The question assumes that there are multiple tabs already ("I have a Google spreadsheet with many tabs"). – w0lf Dec 3 '12 at 10:10

1 Answer