Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Excel HYPERLINK Function

What is the Excel HYPERLINK function?

The Microsoft Excel HYPERLINK function is used to help return a Hyperlink from a specific destination as well as a “friendly name”. You can make use of the Excel HYPERLINK function to establish a clickable Hyperlink with the given formula. Also, the Excel HYPERLINK function can also be used to build links to pages on the Internet, locations of workbooks, or files that have been stored on network servers.

Formula

=HYPERLINK(link_location, [friendly_name])

Explanation

  • link_location – path to the page or file to be opened when clicked. This should be a cell reference, e.g. C3.
  • friendly_name – [optional] The link text that would be displayed in a cell. This would be returned in as clickable hyperlink in blue color.

Example

How to use the Excel HYPERLINK function?

There are two items on the spreadsheet that should be converted to a clickable Hyperlink, one is a web page and the other is the file. Let’s start by converting the web page in cell C3 into a clickable Hyperlink.

Let’s follow a step-by-step guideline below:

  1. Open the working spreadsheet containing cells for the friendly name, Target, and cells where the clickable hyperlink would be generated to.

Figure1. Sample spreadsheet

  1. Click on the cell where the hyperlink would be displayed (D3) and insert the formula =HYPERLINK(C3,B3). This is because cell C3 contains our Target link to build a hyperlink from and B3 has the friendly_name.

Figure2. Click on the cell and insert the formula

  1. Press Enter on your keyboard to display the clickable hyperlink in blue.

Figure3. Press ENTER

  •  
  1. Next up, we create a hyperlink from a file, a worksheet, and a friendly_name. Insert the formula =HYPERLINK(C4, B4) and press Enter.

C4 contains the target and B4 houses the friendly name.

 

Figure4. Final spreadsheet

Notes

*Link_location can be supplied as a cell reference that contains the link path or as a text string. If it is supplied as a text string, the text should be in “quotation marks”.

*If you don’t supply the function with a friendly_name, the HYPERLINK function will display link_location as the friendly_name.

*In summary, the location can be any of the following:

  • A cell reference or a named range
  • A path to a file:
    • has been stored on a local drive
    • stored on a server using a Universal Naming Connection (UNC),
    • To a specific location on the Internet or an Intranet in the URL format.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc