<< Click to Display Table of Contents >> HYPERLINK (hyperlink)

Syntax:

HYPERLINK(TargetAddress [, Text])

Description:

Displays a hyperlink to the specified target address in the cell. The text displayed is either the target address or the text specified in the optional parameter Text.

For example, you can place a link to a web page in a cell. When the user clicks on it, the web browser starts and presents the page.

Links to other PlanMaker documents are possible as well. When clicked, PlanMaker opens the specified document. See examples below.

TargetAddress is the address you want the link to point to. You can use a fixed text string, a calculation, or a reference to a cell that contains the target address. See examples below.

Text (optional) is the text to be displayed in the cell. If it is not specified, the target address will be displayed instead.

Example:

=HYPERLINK("http://www.softmaker.com")

The above hyperlink opens the web page www.softmaker.com in the web browser.

=HYPERLINK("http://www.softmaker.com", "Our Homepage")

Ditto, but instead of the target address, the text "Our Homepage" is displayed as link text.

=HYPERLINK("http://www.softmaker.com#MyAnchor")

The above link opens the web page www.softmaker.com in the browser and jumps to the anchor (target) named "MyAnchor". Alternatively, you could also use the syntax =HYPERLINK("[http://www.softmaker.com]MyAnchor") for this.

=HYPERLINK("C:\My Folder\Filename.pmdx")

The above link opens the file C:\My Folder\Filename.pmdx in PlanMaker.

Note: You can not only open PlanMaker files with this function, but practically any kind of document (provided that it is associated with an application that will open it).

=HYPERLINK("[C:\My Folder\Filename.pmdx]Sheet1!A5")

The above link opens the file C:\My Folder\Filename.pmdx in PlanMaker and jumps to the cell A5 on the worksheet "Sheet1". Note: The entire file path and name has to be enclosed in brackets. Behind the file name, add the name of the worksheet, an exclamation mark and the address of the target cell.

=HYPERLINK("[C:\My Folder\Filename.pmdx]Sheet1!MyRange")

The above link opens the file C:\My Folder\Filename.pmdx in PlanMaker and jumps to the top left corner of the named range "MyRange" on the worksheet "Sheet1".

=HYPERLINK(E1, E2)

The above link opens the target address given in the cell E1. As a link text, the text given in cell E2 is displayed.

See also:

Links can also be created using the procedure described in section Working with links. However, the HYPERLINK function is more flexible.