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'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.