Hyperlink Excel Function

Hyperlink Excel function is an inbuilt function in excel which is used to create hyperlinks for a certain cell, when the hyperlink is created it redirects or takes the user to a specified web page or a location, the value on the cell is not a URL as hyperlink formula has two arguments one is the URL while other is the name we provide to the URL or the display value.

Hyperlink Function formula

Explanation of Hyperlink Function in Excel

The Hyperlink in excel sheet accept the following arguments:

Hyperlink-Function-in-Excel

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Hyperlink Excel Function (wallstreetmojo.com)

How to Insert HYPERLINK in Excel Sheet

How to Execute HYPERLINK in Excel Sheet with Examples

Below Excel, Hyperlink examples illustrate how the Hyperlink function in excel is being used to send an email, open documents, and move between the sheets just by clicking the link.

You can download this HYPERLINK Function Excel Template here – HYPERLINK Function Excel Template

In the first Hyperlink example, you can see the Hyperlink function in excel is used to send an email. When you are sending an email using a link, you should add a prefix ‘mailto:’ to an email address, which is an HTML code to send an email.

The moment you click on the link, it redirects you to the email composer page with the given email IDs in the To recipient list.

Hyperlink EXAMPLE 1-2

Example #1 – How to switch between the tabs

Below, the Hyperlink example shows how to switch between the excel worksheets of a workbook.

Let’s say we would like to redirect the user to a specific range of a worksheet from the index page where you have listed all the links to the contents.

To move internally within the workbook, you need to add a prefix ‘#’ to the sheet name you would like to jump off.

As it can be seen in the snapshot to jump to the sheet: Example1 from another sheet using a hyperlink, the excel hyperlink function can be written as =HYPERLINK(“#Example1!A1″,”to Example1”)

Hyperlink EXAMPLE 1-3

The moment you click the link, it redirects you to the destination worksheet, i.e., A1 cell of the Example1 worksheet.

Alternate method:

The same can also be achieved without writing the Hyperlink function in Excel.

As we mentioned above that selecting the hyperlink option from the shortcut menu or by right-clicking on the text to be converted into a link would give you an option to add a hyperlink in the sheet.

As can be seen in the snapshot, you can choose here the destination/ target to be reached once the user clicks on the given link.

Hyperlink EXAMPLE 1-4

Example #2 –  How to open a document

We will go through one more Hyperlink Example in Excel. Here our aim is to open a word or any document stored in a computer directory.

As can be seen in the snapshot, you can directly pass the path of the document to be launched when the user clicks the link. This will open the file mentioned in the provided link.

Give the complete path where the file is saved along with the document name and its extension (file type) into the excel hyperlink function.

Or you can use the command .. (MS-DOS command) to move backward or forward from the current directory.

Note: The current directory is where the excel workbook is currently stored.

Hyperlink EXAMPLE 1-5

Again, you can also use the alternate method discussed above to achieve the same.

Things to note about the Hyperlink Function in Excel

  • Link_location should be supplied as a text string in quotation marks or a cell reference that contains the link path as text.
  • If friendly_name is not supplied, the Excel HYPERLINK Function will display link_location as the friendly_name.
  • To select a cell that contains HYPERLINK without jumping to the destination, use arrow keys to select the cell. Alternatively, click on the cell and hold the mouse button down until the cursor changes.

Hyperlink Excel Function Video

Recommended Articles

This has been a guide to HYPERLINK in Excel. Here we discuss the HYPERLINK Excel Formula and how to use the HYPERLINK function in Excel along with practical examples and downloadable excel templates. You may also look at these useful functions in excel

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Reader Interactions

Leave a Reply

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