Documentation/Calc Functions/HYPERLINK

Function name:
HYPERLINK

Category:
Spreadsheet

Summary:
Constructs a clickable text hyperlink in the formula cell. When the hyperlink is clicked, Calc opens the specified resource (often in another application) or moves to the specified location in the current spreadsheet.

By default, the formula cell displays the link target as a text string but a more user-friendly text string can be displayed if required.

Syntax:
HYPERLINK(URL[; Cell Text])

Returns:
Returns a text string, representing either the link target (when only one argument is supplied) or the alternative cell text (when a second argument is supplied).

Arguments:
URL is a text string (in quotation marks), or a reference to a cell containing a text string, that specifies the link target.

Cell Text is a text string (in quotation marks) or a number, or a reference to a cell containing one of those types, that specifies alternative text to be displayed in the formula cell instead of the link target.

Additional details:

 * The action necessary to open a hyperlink of this form depends on the current setting of the option ( on macOS). If the option is ticked, then use Ctrl+click with the cursor positioned over the hyperlink; if the option is not ticked, then use left-click with the cursor positioned over the hyperlink.


 * If you want to edit a hyperlinked cell but find that clicking it directly opens the hyperlink, select a nearby cell and navigate to the hyperlinked cell using the keyboard arrows.


 * If a cell contains a HYPERLINK function call (even if the HYPERLINK function is not evaluated), then that cell becomes a hyperlinked cell; that is, if you click on it it will attempt to open the target link. This means, for example, in a cell containing the formula
 * the HYPERLINK function is never evaluated. Nevertheless the cell initially becomes a hyperlinked cell. However, when the formula cell is clicked, the link will fail.
 * the HYPERLINK function is never evaluated. Nevertheless the cell initially becomes a hyperlinked cell. However, when the formula cell is clicked, the link will fail.

Related LibreOffice functions:
None

ODF standard:
Section 6.11.3, part 2

Equivalent Excel functions:
HYPERLINK