In this Excel tutorial, you will learn about inserting a hyperlink in Microsoft Excel. There are different types of hyperlinks, so we will go over a website hyperlink, an email hyperlink, and a phone hyperlink. All three will allow you to access external applications from Excel such as a web browser, a default email program, and even a phone call on your smartphone!
There are several ways to Insert a Hyperlink in Microsoft Excel –
Let’s look into it in more detail!
Watch this video on How to Insert Hyperlinks in Microsoft Excel on YouTube and give it a thumbs-up!
Inserting a Website Hyperlink in Microsoft Excel
You can insert a hyperlink to your website by highlighting the link in the address bar, Right Click, and go to Copy.
Go back to the Excel tab, and Right Click the cell where you want to place the hyperlink.
Click Paste. Then, click on the Blue Link to see if it works.
Next, Right Click on the hyperlink to view the options for editing.
Click Edit Hyperlink.
As you can see, you can customize the Display Text of your hyperlink, and more importantly where the hyperlink leads to on the Where do you want to link to feature. Hit OK.
Conversely, you can remove the link by right clicking the hyperlink and selecting Remove Hyperlink.
Inserting an Email Hyperlink in Microsoft Excel
Our next type of hyperlink is the email address. This method would lead your click directly to a draft of an email addressed to the hyperlink email.
Type an email address into your selected cell. Hit ENTER, and voila, your email hyperlink is created.
Click on the Link and you will be redirected to an Outlook email draft.
Inserting a Smartphone Hyperlink in Microsoft Excel
Lastly, let’s look at how we can create a phone number hyperlink.
Type in tel:(phone number) in the cell and hit ENTER.
Note, that since we are creating this hyperlink on a computer with no calling software, the link will not work to redirect you to a call. Instead, we can open this Excel file on a smartphone, and it will give you the option to call the hyperlink phone number.
Bring up the file on the mobile version of Excel. Click on the hyperlink and hit Link. Click Open. Your smartphone will bring out an option to Call the hyperlink number.
BONUS TIP: Microsoft Excel HYPERLINK Function
If you have a cell that just has a phone number, Click on another empty cell and input this formula: =HYPERLINK(“tel:” & C4) then hit ENTER. It will now create the contents of that cell into a hyperlink. (*C4 is the cell with the phone number with no formula) If you change that phone number, the hyperlink would change automatically, as well.
You can even put a Friendly Name in the formula by inputting:
=HYPERLINK(“tel:” & C4, “Call Me”) then hit ENTER.
The Friendly Name of the link is now “Call Me.”
There you have it! By inserting hyperlinks you can make your Excel projects more interactive. Stay tuned for more tutorials in this blog!