3

How do you open a hyperlink in Google Sheets using only keyboard shortcuts? Google has Alt+Enter which opens the hyperlink, but in a new tab in Chrome. How can you open the hyperlink using only keyboard shortcuts so the hyperlink opens in the current tab of Chrome on Windows?

My hyperlinks link to another cell within the same Google Sheet, just on another tab. For example: 

=IF(NOT(ISBLANK(B4)),HYPERLINK("#gid=1234567892range="&"A"&MIN(ArrayFormula(IF(Projects!A:A=B4,ROW(Projects!A:A),""))),"Link"),"")

I don't want to keep re-opening the same Google Sheet in multiple tabs.

Improve this question
1
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it and maybe upvote it so others can benefit as well.
    – marikamitsos
    Sep 26, 2019 at 19:16

2 Answers 2

Reset to default
2

How can you open the hyperlink using only keyboard shortcuts so the hyperlink opens in the current tab of Chrome on Windows?

You can not.

It has nothing to do with the browser. Google has it that by default all links in spreadsheets open in either a new Tab or a window, depending on how you have set up your browser.
But there is no way you can open them within the same tab or window. And most certainly there is no shortcut.

EDIT (as reminded by Ken)

If I hover over the cell, and click the hyperlink that "pops up" over that cell, it does open in the current tab. It just navigates me over to that cell on that referenced sheet. That works great. But no keyboard shortcut to do the same? Bummer :/

Improve this answer
2
  • 1
    If I hover over the cell, and click the hyperlink that "pops up" over that cell, it does open in the current tab. It just navigates me over to that cell on that referenced sheet. That works great. But no keyboard shortcut to do the same? Bummer :/
    – Ken
    Sep 26, 2019 at 19:17
  • 1
    "Bummer :/" and there is nothing you can do about it. Also. I believe I should add your clarification on the answer as well.
    – marikamitsos
    Sep 26, 2019 at 19:27
0

It's not as good as a single keyboard shortcut, but I have found that if I hit Enter+Tab+Enter, it will open the link in the same tab.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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