HYPERLINK

MS Excel Spreadsheet

See Also

Creates a hyperlink that opens a document stored on a network server, an intranet, or the Internet. When you click the cell that contains the HYPERLINK function, the file stored at link_location is opened.

Syntax

HYPERLINK(link_location,friendly_name)

Link_location    is the path and file name of the document to be opened as text. The path can be to a file stored on a hard disk drive, or the path can be a universal naming convention (UNC) path on a server or it can be a Uniform Resource Locator (URL) path on the Internet or an intranet.

  • Link_location can be a text string enclosed in quotation marks or 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    is 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.

Remark

To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click a cell next to the cell with the hyperlink, and then use the arrow keys to select it.

Example

The following example opens a spreadsheet named Budget Report.xls that is stored on the Internet at the location named example.microsoft.com/report and displays the text "Click for report":

=HYPERLINK("http://example.microsoft.com/report/budget report.xls", "Click for report")