How to use the Hyperlink function in Excel

There are many ways to create Hyperlink links, but if you want to create more identical or similar links, the best and fastest way that Software Tips introduces you is to use the Hyperlink function.

How to use the Hyperlink function in Excel Picture 1

How to use the Hyperlink function in Excel

Functional structure

= HYPERLINK (link_location, [friendly_name])

Inside:

1. Link_location (required argument) is the link to the website or file that is already opened. The link_location can be a reference to a cell containing a link or a string of characters enclosed in quotes containing a path to a file stored on the hard drive, a UNC path on the server, a line. UNC leads on the internet or intranet.
2.  Friendly_name (optional argument) is the link text (also the jump text or anchor text) displayed in the cell. If you omit this, the link_location argument will be displayed as the link text as well.

Note:

1. If the hyperlink does not exist or is broken, the Hyperlink function will display an error when you click the cell.
2. If the function returns an error value of VALUE! Or N / A appears in a cell, most likely the problem is with the friendly_name argument in your Hyperlink function.

Example of using Hyperlink function

Links to other sheets

To link to another sheet, use the formula = HYPERLINK ("# sheet name! A1", "the reference name you want to put").

You have the following example:

How to use the Hyperlink function in Excel Picture 2

To create a link to the " car rental " worksheet in the same file, type the formula = HYPERLINK ("# 'car rental'! A1", "A") and get the result:

How to use the Hyperlink function in Excel Picture 3

When you click on the letter A, Excel automatically moves to cell A1 of the "car rental price" page.

Note: to get to the position of any cell in the worksheet, you just need to replace the position of the cell with A1 in the above formula.

Link to another spreadsheet

To create a link to another workbook, specify the full path to the target worksheet in the following format: " D: Vidugiá xe xe.xlsx" by right-clicking the file you need and selecting Properties .

In a cell without the Hyperlink function, type the formula:

= HYPERLINK ("D: Vidugiá car rental.xlsx", "B"). The result is:

How to use the Hyperlink function in Excel Picture 4

Link to a website

To create a link to a website, enter the link for that site into the link_location argument.

How to use the Hyperlink function in Excel Picture 5

Link to email

To create an email link to someone, you need an email address in the following format: mailto: email_address in the link_location argument.

How to use the Hyperlink function in Excel Picture 6

Hyperlink function does not work

The main reason that the Hyperlink function doesn't work is because the path no longer exists or is broken in the link_location argument. When this error occurs, you should check the destination address of the link, make sure that the link location is provided in the correct format.

So, surely you already know how to create hyperlinks in Excel. Good luck!