The HYPERLINK function creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. When the cell that containing the HYPERLINK function is clicked, Microsoft Excel opens the file that is stored at link_location.

Syntax

=HYPERLINK(link_location,[friendly_name])

Arguments

Argument Description
link_location The path and file name to the document to be opened
[friendly_name] Optional. The text or numeric value that is displayed in the cell

  [friendly_name] can be a value, a text string, a name, or a cell that contains the jump text or value
  If [friendly_name] is omitted, the cell displays the link_location as the jump text

Examples

  A B C
1 Formula Result Notes
2 =HYPERLINK(“http://bestfx.com/report/report.xlsx”, “Click for report”) Click for report Opens a workbook saved at http://bestfx.com/report
3 =HYPERLINK(“[http://bestfx.com/report/report.xlsx]Annual!F10”,D1) D1 text Creates a hyperlink to cell F10 on the Annual worksheet in the workbook saved at http://bestfx.com/report. The contents of cell D1 is displayed as the jump text
4 =HYPERLINK(“H:\FINANCE\1stqtr.xlsx”,”1st Qtr Rpt”) 1st Qtr Rpt Creates an absolute hyperlink to file 1stqtr.xlsx
5 =HYPERLINK(“1stqtr.xlsx”,”1st Qtr Rpt”) 1st Qtr Rpt Creates a relative hyperlink to file 1stqtr.xlsx

Notes on Absolute and Relative References

The address supplied for the link_location argument can be an absolute reference or a relative reference. The difference between these two reference types is shown in the table below.

Absolute Reference Relative Reference

Shows the entire path to the referenced file, e.g.,

H:\FINANCE\Quarterly Reports\1stqtr.xlsx

Refers to the referenced file’s location relative to the current directory, e.g.

If the current file is located at H:\FINANCE, then the relative reference is: Quarterly Reports\1stqtr.xlsx