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
The path for the external source.
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.