[]

Formula Reference
Contacting Us
Getting Technical Support
Formula Overview
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
  - HARMEAN
  - HBARSPARKLINE
  - HEX2BIN
  - HEX2DEC
  - HEX2OCT
  - HISTOGRAMSPARKLINE
  - HLOOKUP
  - HOUR
  - HSTACK
  - HYPERLINK
  - HYPGEOM.DIST
  - HYPGEOMDIST
  - IF
  - IFERROR
  - IFNA
  - IFS
  - IMABS
  - IMAGE
  - IMAGINARY
  - IMARGUMENT
  - IMCONJUGATE
  - IMCOS
  - IMCOSH
  - IMCOT
  - IMCSC
  - IMCSCH
  - IMDIV
  - IMEXP
  - IMLN
  - IMLOG10
  - IMLOG2
  - IMPOWER
  - IMPRODUCT
  - IMREAL
  - IMSEC
  - IMSECH
  - IMSIN
  - IMSINH
  - IMSQRT
  - IMSUB
  - IMSUM
  - IMTAN
  - INDEX
  - INDIRECT
  - INFO
  - INT
  - INTERCEPT
  - INTRATE
  - IPMT
  - IRR
  - ISBLANK
  - ISERR
  - ISERROR
  - ISEVEN
  - ISFORMULA
  - ISLOGICAL
  - ISNA
  - ISNONTEXT
  - ISNUMBER
  - ISO.CEILING
  - ISODD
  - ISOMITTED
  - ISOWEEKNUM
  - ISPMT
  - ISREF
  - ISTEXT
  - JIS
  - KURT
  - LAMBDA
  - LARGE
  - LCM
  - LEFT
  - LEFTB
  - LEN
  - LENB
  - LET
  - LINEST
  - LINESPARKLINE
  - LN
  - LOG
  - LOG10
  - LOGEST
  - LOGINV
  - LOGNORM.DIST
  - LOGNORM.INV
  - LOGNORMDIST
  - LOOKUP
  - LOWER
- Functions M to Q
- Functions R to S
- Functions T to Z

HYPERLINK

This function creates shortcut that opens document stored on the Internet.

Syntax

HYPERLINK(link,[display_name])

Arguments

This function has the following arguments:

Argument	Description
link	Refers to the URL of the document
display_name	[Optional] Refers to the text that appears in the cell; if this is exculede, whole link appears in the cell

Remarks

Click the cell and hold the mouse button until pointer becomes a cross, to select the cell and not jump to the hyperlink destination.

Data Types

Accepts string data for both arguments. Returns string data.

Examples

HYPERLINK("https://developer.mescius.com/", "Click for demo") gives the result Click for Demo

Version Available

This function is available in Spread for Windows Forms 11.0 or later.