=HYPERLINK("" "Click here") displays Click here in the cell and opens the hyperlink when clicked. =HYPERLINK("") displays in the cell and opens the hyperlink when clicked. The examples above illustrate how HYPERLINK works - but not how it should be used.
If any error is returned, the cell ceases to be a hyperlinked cell. = "h" & HYPERLINK("ttp://" "ere is ") & HYPERLINK("evaluates firstly to concatenate "h" & "ttp://" & "forming "" - the address to link to, and secondly to concatenate "h" & "ere is " & "forming "here is - the text that appears in the cell.ģ. The second time "h" & "ot " & "link" are concatenated to form "hot link" - the text that appears in the cell. The first time "h" & "ttp://" & "are concatenated to form "" - the address to link to. = "h" & HYPERLINK("ttp://" "ot ") & HYPERLINK(""link")Įvaluates twice. Ii) The second time, any HYPERLINK function returns celltext (or linkaddress if no celltext is given), and the result of the formula is displayed in the cell. I) The first time, any HYPERLINK function returns linkaddress, and the result of the formula becomes the address to link to. the formula in the cell is evaluated twice. The HYPERLINK function is never evaluated - but nevertheless the cell becomes a hyperlinked cell (although the link will fail - see 2. that cell becomes a hyperlinked cell that is, if you click on it it will attempt to open a page in a browser window.
If a cell contains a HYPERLINK function (even if the HYPERLINK function is not evaluated):ġ. If you need a fuller explanation of the unique way in which HYPERLINK works, it follows now: To edit a hyperlinked cell, select a nearby cell, and navigate to the hyperlinked cell using the keyboard arrows (if you click directly, it will open the hyperlink).įor common, straightforward usage of HYPERLINK, see the Examples section. If celltext is omitted, linkaddress is displayed in the cell. celltext is the text displayed in the cell. Linkaddress is the address (as text) that is opened. HYPERLINK(linkaddress celltext) A cell containing a HYPERLINK function will open a hyperlink when the cell is clicked. Sets a cell to open a hyperlink (in another application) when clicked.
0 kommentar(er)
