Creates a hyperlink inside a cell that, when clicked, opens the address specified.
Syntax
link_address: The URL or address to open. In case of a cell reference, use "#cell_reference". E.g. " www.zoho.com"
Remarks
Zoho Sheet also converts URLs into hyperlinks directly when entered into a cell.
Examples
Formula |
Result |
=HYPERLINK(" www.zoho.com"; "Zoho home page") |
|
=HYPERLINK(" https://www.zoho.com/docs/sheet.html"; "Zoho Sheet") |
|
=HYPERLINK( " https://www.zoho.com/sheet/excel-alternative.html" ) |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com