How to use the HYPERLINK Function in Excel

In this article, we will learn about how to use the HYPERLINK function in Excel.

The HYPERLINK function is a link reference function. It takes the link in the cell as address under friendly name
Syntax:

=HYPERLINK (link_location, [friendly_name])

Link_location : URL link of the address
Friendly_name : [optional]clickable text to be displayed in the cell.
74
Let’s understand this function using it in an example.
75
Here we need to get the link of the address.
Use the formula:

=HYPERLINK(A2,B2)

A2 : URL link
B2 : Friendly_name
76
As you can see, the HYPERLINK function returns the friendly name with link in it. Click the name which will take you to the address of the link.
Copy the formula to other cells using Ctrl + D shortcut key.
77
You can also get the link for the worksheet using the HYPERLINK function in Excel .

As you can see, the function returns the clickable links in excel.
If you don’t provide the optional friendly name. Link_location will be used as friendly name for the link.
78
As you can get from the clickable link in C6 cell.

Hope you understood how to use HYPERLINK function and referring cell in Excel. Explore more articles on Excel info functions here. Please feel free to state your query or feedback for the above article.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube