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




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.

=HYPERLINK(“”,”Read Me!”)

excel hyperlink formula

Without a Friendly Name

You can omit the [friendly_name] argument to only display the path.


excel hyperlink formula

Download Workbook

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.