Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

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")
share|improve this answer
    
This opens a new instance of the spreadsheet -- does not just move to the selected tab. –  user29808 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
    
@JacobJanTuinstra: Adding a new sheet with the "+" on the bottom left or clicking on an existing tab in the lower part of the Sheet shows that new/existing sheet in the same browser window or tab. The behavior of the HYPERLINK function, however, opens a new browser window or tab; rather than changing the view in the current browser window/tab. –  user48461 Sep 27 '13 at 16:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.