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

Syntax:

HYPERLINK(TargetAddress [, Text])

Description:

This displays a hyperlink (a link) to the specified target address in the cell. The displayed text is either the target address or the text specified in the optional parameter Text.

For example, you can use this function to insert a hyperlink to a web page in a cell. If the user clicks on it, their web browser starts automatically and presents this page.

Furthermore, you can insert links to another PlanMaker document, which is automatically opened when you click on this link. See examples below.

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

Text (optional) is the text to be displayed in the cell. If it is omitted, 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 the 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") in this case.

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

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

Note: Not only can you open PlanMaker files with this function, but also 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 in the worksheet "Sheet1". Note: The entire file path and name must be enclosed within square brackets. Directly after 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 entered in cell E1. The content of cell E2 is displayed as a link text.

See also:

Links can also be created using the alternative method described in Using hyperlinks. However, the HYPERLINK function is more flexible.