HYPERLINK function
Summary
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
Syntax
HYPERLINK(link_location, [friendly_name])
The HYPERLINK function syntax has the following arguments:
• Link_location Required. The path and file name to the document to be opened. Link_location can refer to a place in a document — such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a Microsoft Word document. The path can be to a file that is stored on a hard disk drive. The path can also be a universal naming convention (UNC) path on a server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL) path on the Internet or an intranet. Note: Excel for the web the HYPERLINK function is valid for web addresses (URLs) only. Link_location can be a text string enclosed in quotation marks or a reference to a cell that contains the link as a text string. If the jump specified in link_location does not exist or cannot be navigated, an error appears when you click the cell.
• Friendly_name Optional. The jump text or numeric value that is displayed in the cell. Friendly_name is displayed in blue and is underlined. If friendly_name is omitted, the cell displays the link_location as the jump text. Friendly_name can be a value, a text string, a name, or a cell that contains the jump text or value. If friendly_name returns an error value (for example, #VALUE!), the cell displays the error instead of the jump text.
• Link_location Required. The path and file name to the document to be opened. Link_location can refer to a place in a document — such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a Microsoft Word document. The path can be to a file that is stored on a hard disk drive. The path can also be a universal naming convention (UNC) path on a server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL) path on the Internet or an intranet. Note: Excel for the web the HYPERLINK function is valid for web addresses (URLs) only. Link_location can be a text string enclosed in quotation marks or a reference to a cell that contains the link as a text string. If the jump specified in link_location does not exist or cannot be navigated, an error appears when you click the cell.
• Friendly_name Optional. The jump text or numeric value that is displayed in the cell. Friendly_name is displayed in blue and is underlined. If friendly_name is omitted, the cell displays the link_location as the jump text. Friendly_name can be a value, a text string, a name, or a cell that contains the jump text or value. If friendly_name returns an error value (for example, #VALUE!), the cell displays the error instead of the jump text.
Example
=HYPERLINK("http://example.microsoft.com/report/budget report.xlsx", "Click for report")
=HYPERLINK("[http://example.microsoft.com/report/budget report.xlsx]Annual!F10", D1)
=HYPERLINK("[http://example.microsoft.com/report/budget report.xlsx]'First Quarter'!DeptTotal", "Click to see First Quarter Department Total")
=HYPERLINK("http://example.microsoft.com/Annual Report.docx]QrtlyProfits", "Quarterly Profit Report")
=HYPERLINK("\\FINANCE\Statements\1stqtr.xlsx", D5)
=HYPERLINK("D:\FINANCE\1stqtr.xlsx", H10)
=HYPERLINK("[C:\My Documents\Mybook.xlsx]Totals")
=HYPERLINK("[Book1.xlsx]Sheet1!A10","Go to Sheet1 > A10")
=HYPERLINK("[Book1.xlsx]January!A10","Go to January > A10")
=HYPERLINK(CELL("address",January!A1),"Go to January > A1")
=HYPERLINK($Z$1)
=HYPERLINK("[http://example.microsoft.com/report/budget report.xlsx]Annual!F10", D1)
=HYPERLINK("[http://example.microsoft.com/report/budget report.xlsx]'First Quarter'!DeptTotal", "Click to see First Quarter Department Total")
=HYPERLINK("http://example.microsoft.com/Annual Report.docx]QrtlyProfits", "Quarterly Profit Report")
=HYPERLINK("\\FINANCE\Statements\1stqtr.xlsx", D5)
=HYPERLINK("D:\FINANCE\1stqtr.xlsx", H10)
=HYPERLINK("[C:\My Documents\Mybook.xlsx]Totals")
=HYPERLINK("[Book1.xlsx]Sheet1!A10","Go to Sheet1 > A10")
=HYPERLINK("[Book1.xlsx]January!A10","Go to January > A10")
=HYPERLINK(CELL("address",January!A1),"Go to January > A1")
=HYPERLINK($Z$1)