Microsoft® Office Excel® 2007 Inside Out

Using Formulas to Create Hyperlinks

The HYPERLINK function creates a hyperlink in a worksheet cell, based on two text arguments, one of which is optional. The syntax is as follows:

=HYPERLINK(link_location,friendly_name)

In this syntax, link_location, a required argument, is a text value that specifies the target of the link, and friendly_name, an optional argument, is the text that will appear in the cell. If friendly_name is omitted, it is assumed to be the same as link_location. Either argument can be a cell reference. Here are two examples:

=HYPERLINK(http://office.microsoft.com,"Microsoft Office Online")
=HYPERLINK("[\\Cervantes\Rocinante\myfile.xlsx\Sheet2!B29")

The first example displays the text Microsoft Office Online as a hyperlink that ...