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