Lookup and Reference - HYPERLINK Function

Description

The HYPERLINK function creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.

When you click the cell that contains the HYPERLINK function, Microsoft Excel opens the file that is stored at link_location.

Syntax

HYPERLINK (link_location, [friendly_name])

Arguments

Argument Description Required/ Optional
Link_location

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.

 Required
Friendly_name

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.

 Optional

Notes

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

  • To select a cell that contains a hyperlink without jumping to the hyperlink destination, click the cell and hold the mouse button until the pointer becomes a cross Cross, then release the mouse button.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

HYPERLINK Function
advanced_excel_lookup_reference_functions.htm
Advertisements