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

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
up vote 11 down vote accepted


*Spreadsheets created in the old version of Sheets will eventually be converted to the new Sheets, which won’t require any action on your part. More details coming soon.

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


  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)


enter image description here


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



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
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
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
Yes, I would prefer a solution, where the spreadsheet "jumps" to the specified position, like anchors in HTML. – miku Nov 21 '13 at 13:04
According to support.google.com/docs/answer/139561?rd=1 the list view got removed in the "New" Google spreadsheets. – bgoodr Nov 15 '14 at 18:11
The document in the "example link" was migrated to the New Google Sheets and now it doesn't work as was intended when the answer was posted. – Rubén Aug 17 '15 at 17:53

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
More than that, after you left comment, it appears in "Comments" dropdown (besides "Share" buton). Each comment there has timestamp and small arrow for menu. There is "Link to this comment..." item that opens the comment link dialog box for copy and paste. – myroslav Oct 31 '14 at 8:05
As of right now (2014-11-15), the "will then receive an email with a link" does not happen (maybe it once did). I tested this by changing the "+me@emailaddress.com" to my own email address, then clicked on the link to it inside the comment, and examined the email that was sent back to me. No such URL or link was found in the email that was sent. Perhaps I'm misinterpreting this, or Google changed the behavior. – bgoodr Nov 15 '14 at 18:08
As of 2015-02-16, I was able to get an email occasionally that provided a link. It is in the first blue highlighted text that was sent, the link was in the hypertext titled with the name of the spreadsheet, as in: <my name> added a comment to <title of my spreadsheet> where <title of my spreadsheet> had in it a link ending in 'disco=...' which highlighted the cell commented on, in yellow. However, and this is the crazy part, no longer does Google send these emails, I got several, maybe 3-4 emails at first, but now no matter how many times I try, no go. Maybe spam prevention? – likethesky Feb 16 '15 at 15:04
@likethesky I found that this trick doesn't send me an e-mail if I mention myself in the comment, but if I mention a colleague who has access to the sheet, he gets a notification. – CupawnTae Jul 15 '15 at 8:36

Your Answer


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.