How to open hyperlinks in excel without mouse-click; is there any shortcut key/Keys

Press the menu key and then press 'O' or 'o'.

More about Menu Key: http://en.wikipedia.org/wiki/Menu_key


Create a macro with the following. The cell with the link should only include text of the hyperlink (and not use the Excel function hyperlink with an embedded link). Note that the "... chrome.exe " has a [space] between exe and quote (").

Sub ClickHyperlnk()
'
' ClickHyperlnk Macro
'
' Keyboard Shortcut: Ctrl+d
'

With Selection.Interior
    URL = ActiveCell.Value
    Shell "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe " & URL, vbNormalNoFocus

End With

End Sub

This is an old post but maybe it could help someone searching for this shortcut. To open a link without going through "Edit Links" follow these couple of steps:

  • click on a cell that is linked to another file
  • then press Ctrl + [

This will open the linked file. Hope this helps.