1

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.

  • 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 at 19:16
1

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 :/

  • 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 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 at 19:27

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.