O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required