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!”)

excel hyperlink formula

Without a Friendly Name

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

=HYPERLINK(“https://www.spreadsheetweb.com/blog/”)

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.