Excel Hyperlink with Shortcut Key: 3 Methods

Method 1 – Shortcut to Add Hyperlink in Excel

The easiest way to add hyperlinks in Excel is to use a shortcut keyboard command. First,

➤ Select the cell where you want to add the hyperlink.

➤ Press CTRL+K.

EXCEL HYPERLINK SHORTCUT

The Insert Hyperlink window will appear.

EXCEL HYPERLINK SHORTCUT

➤ Paste the address of the webpage you want to link in the Address box.

You can also change the text displayed in your selected cell from the Text to Display box if you want to.

➤ Click OK.

EXCEL HYPERLINK SHORTCUT

A hyperlink will be added to your selected cell. If you put the cursor on that cell, you will see the hyperlink with two instructions.

EXCEL HYPERLINK SHORTCUT


Method 2 – Add Hyperlink from the Context Menu in Shortcut

➤ Copy the link of the webpage from your web browser.

➤ Select the cell and press SHIFT+F10 to open the Context menu.

CONTEXT MENU

Now,

➤ Use different ARROW Keys to navigate through the context menu.

➤ Expand the option Link using the RIGHT ARROW key.

You will see the link you’ve previously copied.

Select this link and press ENTER.

HYPERLINK

A hyperlink will be added to your selected cell. If you put the cursor on that cell, you will see the hyperlink with two instructions. You can click once on the link to open the page on your website or click and hold to select the cell.

EXCEL HYPERLINK SHORTCUT


Method 3 – Using VBA to Create a Shortcut for Opening Hyperlink

➤ Press ALT+ F11.

Open the VBA window. After that,

➤ Go to the Insert tab and select Module.

Open the Module(Code) window.

VBA

➤ Type the following code in the Module(Code) window,

Sub Open_Hyperlink()

       ActiveCell.Hyperlinks(1).Follow

End Sub

The code will create a Macro named Open_Hyperlink, which will activate the selected cell.

CODE

➤ Close or minimize the VBA window and press ALT+F8.

It will open the Macro window.

➤ Select  Open_Hyperlink from the Macro name box and click on Options.

OPTIONS

The  Macro Options window will appear. Now,

➤ Insert a key in the Shortcut key box.

We inserted n. So whenever I press CTRL+N, the selected cell will be activated.

➤ Click on OK.

ASSIGN SHORTCUT

➤ Close the Macro window.

MACRO

Select the cell with the hyperlink and press CTRL+N (the key you have assigned to run the Macro). It will open the web page in your web browser.

EXCEL HYPERLINK SHORTCUT


Download Practice Workbook


Related Articles

<< Go Back To Create Hyperlink in Excel | Hyperlink in Excel | Linking in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Prantick Bala
Prantick Bala

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo