0

I am using a Google Sheets to organize an upcoming project. On the first tab I have every task listed, and who the actor should be for that task. I plan on sharing this sheet with my team.

Is it possible to 'link' one cell in one sheet to a cell in another tab (so they see their name - click on it - and are moved to a specific cell in another tab)?

migrated from superuser.com Nov 14 '14 at 18:59

This question came from our site for computer enthusiasts and power users.

1

You can use 'Hyperlink' formula to enable switching between one sheet to another sheet or another spreadsheet when you click on a cell. You need to copy the sheet or spreadsheet URL from the address bar and use it in the 'Hyperlink' URL and also, name the cell text in this formula itself.

Note: For some reasons, if the URL changed then this may not work.

Please refer the screenshot: Hope this helps.

enter image description here

  • This is great - but it only moves me from one sheet to another - It doesnt move the cursor to the individual cell correct? I used =hyperlink("googlesheetaddress", 'Sheetname'!C7) - this gets me to the sheet - and then names the link what is in the field 'Sheetname'!C7 - but I want to move to that cell directly. Any ideas? – Ruben Baden Nov 12 '14 at 23:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.