Google Sheets – Insert Bookmark

bookmarksgoogle sheets

I know you can do this with a Google Doc, but how about a Google Spreadsheet?

I'd like to have a bookmark and then link into that cell of the spreadsheet from an HTML document.

Best Answer

There is no real way if linking to a cell in Google Spreadsheets (I'm trying to build one using HTTP GET, but I'm stuck right now), but you can use a little trick I've found here.

Insert/Comment at a specific cell, and, in that comment "plus someone" - that is, type "+" and then the person's email or name NOTE: you will get a list of people in your domain as soon as you type the "+", filtered as you start typing their name/email the person you "plussed" will get an email with both the contents of the cell and your comment the link in that email will take them DIRECTLY TO THE TARGET CELL with the comment activated.

Add the person you want to send the link to, or yourself to get the link.