Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm curious to know if there's a way to create a table of contents within a Google Drive Spreadsheet. I would like to be able to set the active cell in the spreadsheet based on what cell (or contents of the cell like a hyperlink) in the TOC is clicked.

It doesn't look like there is a way to do this with hyperlinks as they only can link you to a spreadsheet but not any specific cell or sheet. Perhaps some code could capture a cell clicked event and set the active cell accordingly?

share|improve this question
Can you share a spreadsheet with us? – Jacob Jan Tuinstra Jan 2 '13 at 8:31
I've since discovered that hyperlinks can be used to bring you to a specific sheet by using docs.google.com/a/DOMAIN/spreadsheet/ccc?key=YOUR_DOC_ID#gid=X where X is the index of the sheet starting with 0 but this still is not targeted enough for what I'm trying to do. I need to get to a specific target cell. @JacobJanTuinstra Any ol spreadsheet will do. Why do you want me to share a specific one with you? – Woodys Pawn Shop Feb 27 '13 at 21:03
Having an example file with the expected outcome, gives much more clarity. I for sure am better off with a shared file. It's your choice. – Jacob Jan Tuinstra Feb 28 '13 at 7:21
@JacobJanTuinstra Here's an example -- SpreadSheet – Woodys Pawn Shop Apr 4 '13 at 19:28

Your Answer


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

Browse other questions tagged or ask your own question.