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.

One can link to a Google Spreadsheet via key, and via key and worksheet id:

  • https://docs.google.com/spreadsheet/ccc?key=SOME_KEY
  • https://docs.google.com/spreadsheet/ccc?key=SOME_KEY#gid=WORKSHEET_ID

Is it also possible to link to a certain row or even cell via URL query parameters or fragments? Similar to the anchor link mechanism in HTML?

share|improve this question

2 Answers 2

up vote 8 down vote accepted
+100

Yes, it is possible to link to a row by using the following link.

Link

https://docs.google.com/spreadsheet/lv?
  key={your_key}&                // spreadsheet key
  type=view&                     // view (list under menu view)
  gid=0&                         // sheet number
  f=true&                        // markup parameter
  sortcolid=-1&                  // sort parameter
  sortasc=true&                  // sort parameter (asc/desc)
  page=4&                        // row to edit (counts for 5)
  rowsperpage=1                  // number of rows per page (needs to be n=1)

Screenshot

enter image description here

Example

The following link opens the file, created in this answer, and catches the 5th row: example link

Reference

Blogpost:
http://mashe.hawksey.info/2013/07/how-to-open-a-google-spreadsheet-at-a-specific-row-for-editing/

Martin Hawksey:
is an active blogger, predominantly writing about Google Apps Scripts in combination with Google Spreadsheets. See his blog for more interesting stuff or follow him on Google+.

share|improve this answer
2  
This link opens a list view - any possibility for linking directly to a cell in edit view (as I suspect the OP wants)? –  Vidar S. Ramdal Nov 18 '13 at 9:17
    
@VidarS.Ramdal be my guest to add the solution. Thanks for the upvote. –  Jacob Jan Tuinstra Nov 18 '13 at 9:22
1  
Not that this trick is not a good one (it is), but it gives a completely different view of the spreadsheet data, with only the single row visible. The OP's example links is for /ccc, which is the full edit view, so I suspect that's what he (and I) would prefer. Maybe the OP could clarify. –  Vidar S. Ramdal Nov 18 '13 at 9:45
1  
@JacobJanTuinstra, updated my question, though your answer is not wrong - and probably the closest solution to the problem. –  miku Nov 21 '13 at 13:38
1  
@JacobJanTuinstra, indeed :) - if you happen to be around, try to ping me and I'd happily invite you for a drink. –  miku Nov 21 '13 at 14:39

One workaround is to add a comment to the cell. In the comment write +email-address, for e.g. "This comment is to link to the cell for +me@emailaddress.com".

"Me@emailadress.com" will then receive an email with a link, that if you click it, will automatically highlight that particular cell+comment in the spreadsheet.

I'm not sure, but you theoretically ought to be able to share that link with others who have access to the spreadsheet and the cell should highlight for them as well.

share|improve this answer

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.