Zoho Sheet HYPERLINK Function: Labels, URLs and Cell Navigation
Create readable URL and internal-cell links with complete label/target fixtures and clear navigation and access limitations.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
HYPERLINK creates a clickable link whose destination and visible cell label can be supplied separately. This is useful for a small navigation index or reference list: a readable label can describe a destination without placing a long address in every displayed cell.
Availability and evidence
The official HYPERLINK reference was retrieved October 15, 2026. The original introduction release and last functioning version are unknown from the checked sources. The current web reference does not establish mobile or offline parity.
The examples below specify expected labels and destinations from the documented arguments. No native Zoho session, click navigation or permission test was executed. A correctly constructed link does not establish that its destination is currently reachable or accessible to a recipient.
Syntax and the displayed label
HYPERLINK(link_address; [cell_text])
link_address is the address to open. Optional cell_text supplies the visible label; omitting it displays the address itself. Zoho also documents a #cell_reference form for an internal cell target.
Use double quotes for literal text and addresses in the formula. A cell reference supplying an address is different from a literal string containing that reference’s characters. The examples use the help’s semicolon argument separators.
Complete two-column link fixture
Enter the following address and label pairs in A2:B4. In C2 enter =HYPERLINK(A2;B2) and fill down.
| Row | A: Address | B: Label | Expected visible label |
|---|---|---|---|
| 2 | https://www.zoho.com/ | Zoho home | Zoho home |
| 3 | https://www.zoho.com/sheet/ | Zoho Sheet | Zoho Sheet |
| 4 | https://help.zoho.com/portal/en/kb/sheet | Sheet help | Sheet help |
The expected destination in each row is exactly the address stored in column A. These public first-party addresses are example strings; no successful browser navigation is claimed for the generated cells.
To compare the default display, put =HYPERLINK(A2) in D2. The documented target label is the full address https://www.zoho.com/. The destination remains the same as C2 even though its visible label differs.
Example: make the destination explicit
=HYPERLINK("https://www.zoho.com/sheet/";"Open Sheet") has expected label Open Sheet and destination https://www.zoho.com/sheet/.
Changing only the label to Sheet overview does not change that address. Conversely, changing the address cell while keeping the label unchanged changes the target without visibly explaining the change. Keep the address column available for review when accuracy matters.
Internal navigation with a visible target
Create a simple worksheet index: put Inputs in A20, Calculations in A40 and Summary in A60. The following formulas use Zoho’s documented hash-prefixed cell-reference pattern:
=HYPERLINK("#A20";"Go to inputs")=HYPERLINK("#A40";"Go to calculations")=HYPERLINK("#A60";"Go to summary")
The independent label/target pairs are Go to inputs → #A20, Go to calculations → #A40 and Go to summary → #A60. The labels are not themselves cell references; the first argument specifies the destination.
This fixture stays within ordinary cell references. The reference does not establish a complete syntax for cross-sheet names with spaces, external workbook anchors or encoded fragments, so those forms are not guessed here. Native scrolling and selection behavior were not tested.
Advanced: build a maintainable index
For a larger fictional report, retain three fields: section identifier, display label, and target. Example records can be input / Input assumptions / #A20, calc / Calculation area / #A40, and summary / Summary output / #A60.
Generate each link from the label and target fields, and audit them as separate values. There are three sections and three distinct targets in this fixture. If two rows accidentally use #A20, their labels can still look different while both point to the same cell.
A structural edit can move content relative to a literal target string. This guide does not claim that a quoted #A20 string automatically tracks every row insertion or move. Recheck the index after rearranging a worksheet rather than assuming that a readable label proves the destination is still correct.
Advanced: distinguish link creation from access
A link to a restricted document does not grant permission to read that document. A syntactically valid address can also lead to a missing page, a changed resource or a sign-in screen. Treat construction, navigation and authorization as separate checks.
For a shared reference list, use labels that accurately describe the destination and keep the address inspectable. Avoid embedding secrets or sensitive query-string data in example URLs. The fixture uses only public addresses and ordinary internal cell targets.
Errors and troubleshooting
Zoho’s help associates missing double quotes around a literal URL with #NAME!. Check quotes, the function name and referenced address cells if the formula fails to parse. If the label is unexpectedly a long address, confirm whether the optional second argument was omitted.
The shared error table includes generic lookup, type and reference descriptions; it does not prove that an inaccessible website returns a spreadsheet #N/A! error. A click failing to open a page is not automatically a formula-calculation error.
If a cell displays plain text, verify that the stored content is the intended formula rather than an imported text representation. Zoho also auto-links directly entered URLs, but that convenience does not establish identical behavior for every pasted format or every client.