One of the most powerful tools in the digital world.

Author: Jake Heimowitz
Jake Heimowitz
Jake Heimowitz
IU Kelley School of Business Class of '25. I worked for Wall Street Oasis the summer following my freshman year of college at IU which undoubtedly broadened my understanding of financial research. I've since interned with Oppenheimer & Co as an Equity Research Summer Analyst and am excited to continue my career within finance.
Reviewed By: Andy Yan
Andy Yan
Andy Yan
Investment Banking | Corporate Development

Before deciding to pursue his MBA, Andy previously spent two years at Credit Suisse in Investment Banking, primarily working on M&A and IPO transactions. Prior to joining Credit Suisse, Andy was a Business Analyst Intern for Capital One and worked as an associate for Cambridge Realty Capital Companies.

Andy graduated from University of Chicago with a Bachelor of Arts in Economics and Statistics and is currently an MBA candidate at The University of Chicago Booth School of Business with a concentration in Analytical Finance.

Last Updated:November 25, 2023

What is the HYPERLINK Function?

The hyperlink is one of the essential elements of the modern internet. It allows us to quickly and easily navigate between different pages and resources.

This function is a tool that allows users to create hyperlinks in their documents. 

But where did the hyperlink come from?

The first known use of the hyperlink was in the early 1990s, when Tim Berners-Lee, the creator of the World Wide Web, used it to link different documents together. Since then, it has become an integral part of the internet, and there are now billions of them.

It has come a long way since its humble beginnings. It has become an essential tool for using the internet and has changed how we interact with information.

This function can create links to external websites or other parts of the document itself. 

The function is a great way to make your document more interactive and user-friendly. 

To use the function, select the text you want to hyperlink and click on the "Insert Hyperlink" button. From there, you can enter the website URL to which you want to link. 

You can also add a tooltip to your hyperlink, which will appear when the user hovers over the link. 

What does the HYPERLINK function do? 

The function is one of the most powerful tools in the digital world. It allows users to quickly and easily connect to other websites and resources. And it's not just for web browsers - the function is also used in email, document files, and more.

So why is the function so powerful? There are a few reasons. 

First, it's a quick and easy way to connect to other resources. Second, it's a great way to share information and resources with others. Third, it can create powerful links between different websites and resources.

A hyperlink function is a mighty tool that can be used in various ways. Whether you're looking to connect to other resources quickly or you're looking to share information with others, the function is a great option.

The function creates links between different pages on the internet. This function is typically used in HTML and CSS code to create links between web pages. However, it can also be used in other coding languages, such as Java and PHP.

HYPERLINK Function Formula

The syntax is as follows:

HYPERLINK (link_URL, [name])

  • link_URL: This is the webpage you want the hyperlinked text to bring you to once you click it
  • Name: this is an optional feature where you can change the text that is hyperlinked to display whatever you want 

They are usually displayed in blue, although they can be styled with CSS to use a different color. The browser will navigate to the target destination when a user clicks on a hyperlink.

The syntax in CSS is simple:


<a href="url">link text</a>


The ```href``` attribute specifies the URL of the target destination. The ```link text```

How to use the HYPERLINK Function in Excel?

Let's understand this by taking up a few examples:




The hyperlink function is a powerful tool that can be used to create links to other parts of a document or other websites. Using the function, you can make it easier for readers to navigate your document or find more information on a particular topic.

There are a few things to keep in mind when using the function: 

  1. First, it's essential to use descriptive text for your link to let readers know where they will be taken when clicking on it. 
  2. You should test your links to make sure they are working properly. 
  3. Finally, you should use caution when linking to external websites, as you don't want to send readers to a site that is not safe or reputable.

Overall, they help us move around the web, discover new information, and build relationships between different parts of the internet. They are essential to how the internet works and are vital for a positive user experience.

Researched and authored by Jake Heimowitz | LinkedIn

Reviewed and edited by James Fazeli-Sinaki | LinkedIn

Free Resources

To continue learning and advancing your career, check out these additional helpful WSO resources: