In this Article
- HYPERLINK Function Description:
- Formula Examples:
- Syntax and Arguments:
- Additional Notes
- How to use the HYPERLINK Function in Excel:
- HYPERLINK Function
- HYPERLINK Function – Cell Reference
- HYPERLINK Function – Sheet Reference
- HYPERLINK Function – File Location
- HYPERLINK Function – Email Address
- HYPERLINK Function – Webpage
- HYPERLINK, INDEX & MATCH Function
- Multiple HYPERLINKS
This Excel Tutorial demonstrates how to use the Excel HYPERLINK Function in Excel to create a clickable link, with formula examples.
HYPERLINK Function Description:
The HYPERLINK Function Creates a clickable link. The link may refer to a webpage, external document, or a cell within the active workbook.
|Website||=HYPERLINK(C5,D5)||Excel Boot Camp|
|Reference in Excel||=HYPERLINK(C6,D6)||Hyperlink|
Syntax and Arguments:
The Syntax for the HYPERLINK Formula is:
Function Arguments ( Inputs ):
link_location – The file path, web address, or link address. Example: “www.excelbootcamp.com”
friendly_name – The link name to display. Example: Excel Boot Camp
Use the HYPERLINK Function to create a hyperlink to a cell within the workbook, an external file, or a webpage. Clicking the link will “goto” to reference. Depending on the type of hyperlink, this may open a web browser, another file, or simply jump to the referenced cell in the activate workbook.
To select a cell containing a hyperlink, without opening it, select the cell using the arrow keys.
If you use the hyperlinks that open webpages in Excel you may want to change the text that identifies the link(called Anchor text in webspeak).
Usually you can just type a URL in a cell and it automatically converts to a Hyperlink. This works fine for linking to Domains, however when I link to individual pages the link looks long and ugly. Fortunately Excel provides a way to choose the text that displays. Excel calls it friendly_name.
To control the text that displays for a Hyperlinked cell, enter your link as follows:
=HYPERLINK(“https://www.automateexcel.com/excel”,”Automate Excel Home Page”)
Return to the List of all Functions in Excel
How to use the HYPERLINK Function in Excel:
To use the AND Excel Worksheet Function, type the following into a cell:
After entering it in the cell, notice how the AND formula inputs appear below the cell:
You will need to enter these inputs into the function. The function inputs are covered in more detail in the next section. However, if you ever need more help with the function, after typing “=HYPERLINK(” into a cell, without leaving the cell, use the shortcut CTRL + A (A for Arguments) to open the “Insert Function Dialog Box” for detailed instructions:
For more information about the HYPERLINK Formula visit the
The HYPERLINK Function creates a clickable shortcut which redirects users from one location to another. The location can be a cell/sheet in a workbook, another workbook, email address, file on the internet or a network server.
Once the hyperlink is created, the clickable shortcut or [friendly_name] is the text that displays instead of the entire URL.
HYPERLINK Function – Cell Reference
The HYPERLINK Function can jump to a cell reference within the same workbook.
=HYPERLINK(“#T6”, “Go to Cell T6”)
HYPERLINK Function – Sheet Reference
Similarly the HYPERLINK Function can also jump to a sheet reference within the same workbook.
=HYPERLINK(“#’example3′!A1″,”Jump to Sheet example3”)
HYPERLINK Function – File Location
The HYPERLINK Function can open a different workbook or any file present on your system.
Note: the hyperlink will not work if you change file location
In case the file location is expected to change, we can use a relative path in the HYPERLINK Function.
=HYPERLINK(“Excel files\Book3.xlsx”,”Open Book3″)
HYPERLINK Function – Email Address
The HYPERLINK Function can send a message to a specific recipient.
=HYPERLINK(“mailto:[email protected]”,”Drop us an email”)
HYPERLINK Function – Webpage
The HYPERLINK Function can redirect users to a specific webpage.
HYPERLINK, INDEX & MATCH Function
The HYPERLINK Function can be used with INDEX & MATCH Function to create hyperlinks that pull a matching value & create a shortcut to it.
=HYPERLINK(“#”&CELL(“address”, INDEX(A2:A6, MATCH(D2, B2:B6,0))), INDEX(A2:A6, MATCH(D2, B2:B6,0)))
When using the HYPERLINK Function, multiple hyperlinks can be edited at the same time. Open the Find & Replace dialogue by pressing Ctrl+H.
- In the dialogue, enter the old link in Find what: box & new link in the Replace with: box.
- Click the Look in: dropdown and select Formulas.
- Now click Replace All button