Author: Oscar Cronquist Article last updated on April 16, 2018

The HYPERLINK function allows you to build a link in a cell pointing to something else like a file, workbook, cell, cell range or a webpage.

You can then press with left mouse button on that link to open a file or quickly navigate to a location in a workbook.

Excel function syntax

HYPERLINK(link_location, [friendly_name])


Link_location Required. Depending on what you want to create a link to you have these options:

  • File - Full hard drive path to file and file name + file extension
  • File on a server - Full hard drive path to file and file name + file extension
  • File on the internet - HTTP/HTTPS address + filename and extension
  • Workbook - Full hard drive path to workbook and workbook name
  • Webpage - HTTP/HTTPS address
  • Bookmark in a word document
friendly_name Optional. A value or a cell reference used by the HYPERLINK function to show link text, in the cell. This argument is optional, the HYPERLINK function displays the link location if the argument is missing.


To select a cell without performing the hyperlink action press and hold on the cell until a cross appears, see animated image below.

If you use a cell reference as an argument you can make the function dynamic. This allows the HYPERLINK function to change depending on the value in the cell that the cell reference points to.

Many of the articles shown below are built with that technique.