The Excel HYPERLINK formula is a Lookup & Reference function that can establish a connection to an external source such as a specific website, location in the document, or a different document. In this guide, we’re going to show you how to use the Excel HYPERLINK formula and also go over some tips and error handling methods.
Supported versions
- All Excel versions
Excel HYPERLINK Formula Syntax
HYPERLINK(link_location, [friendly_name])
Arguments
| link_location | The path for the external source. |
| [friendly_name] | Optional. The text label to be displayed in the cell. If omitted, the path itself will be displayed instead. |
Examples
With a Friendly Name
To create a hyperlink with a friendly name (label), enter a text value for the [friendly_name] argument.
=HYPERLINK("https://www.spreadsheetweb.com/blog/","Read Me!")
Without a Friendly Name
You can omit the [friendly_name] argument to only display the path.
=HYPERLINK("https://www.spreadsheetweb.com/blog/")
Summary and Tips
- To select a cell containing the Excel hyperlink formula without jumping to the target location, click on the cell, and hold down the left mouse button until the pointer becomes a cross.
- To point a specific reference within the same workbook, start the reference with a hashtag (#). For example, #Sheet2!A1
- You can link a document in your local drive, or a shared location on the network.
- You do not need to enter the full path if the target file is in the same location as the existing document.
