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.
- All Excel versions
Excel HYPERLINK Formula Syntax
|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.|
With a Friendly Name
To create a hyperlink with a friendly name (label), enter a text value for the [friendly_name] argument.
Without a Friendly Name
You can omit the [friendly_name] argument to only display the path.
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.