Using the Hyperlink Function in Excel

There are multiple ways to create Hyperlinks, but if you want to add more identical or similar links quickly, the best and fastest method recommended by Software Tips is to use the Hyperlink function.

Using the Hyperlink Function in Excel

Function Structure

=HYPERLINK(link_location, [friendly_name])

Where:

• Link_location (mandatory argument) is the path to the webpage or file already open. Link_location can be a reference to a cell containing a link or a string enclosed in double quotes containing a path to a file stored on the hard drive, UNC path on a server, UNC path on the internet, or an intranet.
•  Friendly_name (optional argument) is the link content (also known as jump text or anchor text) displayed in the cell. If you omit it, the link_location argument will always be displayed as the link content.

Note:

When the link URL is invalid or broken, the Hyperlink function will display an error upon clicking the cell.

Illustration of utilizing the Hyperlink function

Linking to different sheets

To link to another sheet, you utilize the formula =HYPERLINK('#sheet name!A1', 'desired reference name').

Linking to another spreadsheet

To create a link to another spreadsheet, you need to specify the full path to the target spreadsheet in the following format: 'D:\Example\car rental prices.xlsx' by right-clicking on the file you need, selecting Properties.

In the cell containing the Hyperlink function, type the formula:

=HYPERLINK('D:\Example\car rental prices.xlsx',' B'). The result obtained is:

Linking to a website

To create a link to a website, input the URL of that website into the link_location parameter.

Linking to send an email

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

Hyperlink Functionality Failure

The primary reason for Hyperlink function failure is the absence or corruption of the link_location parameter. When encountering this error, verify the destination address of the link, ensuring that the link location is provided in the correct format.

So, now you must be familiar with the process of creating Hyperlinks in Excel. Wishing you all success!