How to open hyperlinks in excel without a mouse click; is there a shortcut key / key

Question

I have many hyperlinks in the excel-sheet column.

Is there / Is there a combination of keys / keys so that after going to each cell (using the keyboard) I can open them in a browser without using a mouse?

Answer 1

Press the menu key, and then press “O” or “o”.

More on the menu key: http://en.wikipedia.org/wiki/Menu_key

Answer 2

Create a macro with the following. The cell with the link should include only the text of the hyperlink (and not use the hyperlink of the Excel function with an embedded link). Note that "... 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 

Answer 3

This is an old post, but maybe it can help someone find this shortcut. To open a link without going through "Edit Links", follow these steps:

• click on the cell associated with another file
• then press Ctrl + [

This will open the linked file. Hope this helps.

Answer 4

go to excel view tab

• Click on micro
• Click "Micro Record"
• enter text into the shortcut key, i.e. (Ctr + Q or q)
• enter ok
• Press the menu key, and then press "O" or "o" in excel. Where is your hyperlink data and enter
• go back to browse> micro> click on the micro stop button

Now you can use your short key, i.e. Ctr + Q or q For hyperlinks in excel

Answer 5

 Sub hyhperlink() ' ' hyhperlink Macro ' opens hyperlink ' ' Keyboard Shortcut: Ctrl+Shift+X ' With Selection.Interior Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True End With End Sub 

or record a macro for this operation

Answer 6

To open a hyperlink in an excel file, try the following

Select a cell. Press the application key (menu key). Press the O key twice. Press the Enter key.

This works well for me.

Answer 7

In Excel 2016 (English version), I would say that the easiest way to do this is

• press the menu key (which has a similar effect for a right click)
• press o twice
• press enter.

The first "o" goes to "sort"; the second "o" goes to "Open Hyperlink" and then "Enter" opens the hyperlink.

On a keyboard that does not have a menu key, you can press Shift + F10 instead.

Answer 8

You can make a keyboard shortcut for the formula / function of the hyperlink.

Just press ALT + F11, copy and paste the script below:

 Sub OpenHyp() Workbooks.Open "FOLDER ADDRESS\" & ActiveCell.Value & "FILE EXTENSION" End Sub 

replace the FOLDER ADDRESS = you can find it in the address bar of the file location, just copy, paste and add "\" at the end of the file address.

no need to replace ActiveCell.Value = this is the file name of your file, usually the contents of the cell.

replace the FILEEXTENSION = for PDF used by ".pdf", for a regular Excel file, use ".xlsx" and so on.

Then go to the developer tab, click "Macros", select the "OpenHyp" code that we created and click "Option". Now you can put a shortcut key

Hope this helps.

Answer 9

I found that this command does not work for me with 'o' twice, perhaps because I have a column of hyperlinks? who knows.

What am I doing this:

1. Select cell
2. Menu key
3. Up arrow
4. To come in

Opening a link is the last sentence of the menu, so go to the last option. Pressing Enter activates it.

Chears

Ben