The HYPERLINK function allows you to build a link in a cell pointing to something else like

  • A file on your hard drive
  • Excel workbook
  • A cell in your workbook
  • A cell range in your workbook
  • Webpage

You can then click on that link to open a file or quickly navigate to a location in a workbook.

Excel function syntax

HYPERLINK(link_location, [friendly_name])

Arguments

Link_location - 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 - 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.

Comments

To select a cell without performing the hyperlink action click 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.