Pinterest Pixel

Inserting a Hyperlink in Microsoft Excel

In this Excel tutorial, you will learn about inserting a hyperlink in Microsoft Excel.  There are different... read more

John Michaloudis
Posted on

Overview

Inserting a Hyperlink in Microsoft Excel | MyExcelOnline Inserting a Hyperlink in Microsoft Excel | MyExcelOnline

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.
Inserting a Hyperlink in Microsoft Excel
Go back to the Excel tab, and Right Click the cell where you want to place the hyperlink.
Inserting a Hyperlink in Microsoft Excel

See also  FILTER Function in Microsoft Excel - The Easy Way

 

Click Paste. Then, click on the Blue Link to see if it works. 

Inserting a Hyperlink in Microsoft Excel

 Next, Right Click on the hyperlink to view the options for editing.  

Inserting a Hyperlink in Microsoft Excel

 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. 

Inserting a Hyperlink in Microsoft Excel

Conversely, you can remove the link by right clicking the hyperlink and selecting Remove Hyperlink. 

Inserting a Hyperlink in Microsoft Excel

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.

Inserting a Hyperlink in Microsoft Excel

Click on the Link and you will be redirected to an Outlook email draft.

Inserting a Hyperlink in Microsoft Excel

Inserting a Phone Hyperlink in Microsoft Excel

See also  Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide

Lastly, let’s look at how we can create a phone number hyperlink. 

Type in tel:(phone number) in the cell and hit ENTER. 

Inserting a Hyperlink in Microsoft Excel

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. 

Inserting a Hyperlink in Microsoft ExcelInserting a Hyperlink in Microsoft Excel

Inserting a Hyperlink in Microsoft Excel

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. 

See also  MAX Formula in Excel

Inserting a Hyperlink in Microsoft Excel

  You can even put a Friendly Name in the formula by inputting: 

=HYPERLINK(“tel:” & C4, “Call Me”) then hit ENTER. 

Inserting a Hyperlink in Microsoft Excel

The Friendly Name of the link is now “Call Me.” 

Inserting a Hyperlink in Microsoft Excel

 

There you have it! By inserting hyperlinks you can make your Excel projects more interactive. Stay tuned for more tutorials in this blog!

If you like this Excel tip, please share it
Inserting a Hyperlink in Microsoft Excel | MyExcelOnline Inserting a Hyperlink in Microsoft Excel | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...