Go Back

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:
Here are some problems that our users have asked and received explanations on

trying to make email hyperlink function, body formatting goes wrong
Solved by V. U. in 26 mins
What does "","" state in a hyperlink formula in excel ? partial context being : =IF(G15="","",HYPERLINK("https:
Solved by I. F. in 25 mins
Need to generate a new column using a SQl which generates a hyperlink and exports it with a hyperlink alias (Keeping the hyperlink active) to excel. This exports the following output for link column: =HYPERLINK("http://mycompany.com/order/1","[Notes]") Excel does not automatically consider the output as a formula.
Solved by I. L. in 25 mins

Leave a Comment

avatar