Microsoft® Office Excel 2003 Inside Out

Using the HYPERLINK Function

The HYPERLINK function creates a hyperlink in a worksheet cell, based on arguments you supply. The syntax is

=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 a couple of examples:

=HYPERLINK("http://www.microsoft.com","Microsoft Web Site")

=HYPERLINK("[\\myserver\myfile.xls]Sheet2!B29")

The first example displays the text "Microsoft Web Site" as a hyperlink that connects to http://www.microsoft.com. Note that you must ...