HYPERLINK in Google Sheets: Labels, URL Rules and Blank Text

=HYPERLINK(url, [link_label])

The URL is required. The optional label defaults to the URL. Either argument can be a cell reference; literal text needs double quotes. Google’s HYPERLINK reference specifies the accepted URL forms and label behavior.

Use an explicit https:// destination where available. If the protocol is omitted, the documented assumption is http://; it is not an automatic HTTPS upgrade.

Enter this table in A1:B4 as plain values:

In C1 enter Reference. Fill this formula from C2 to C4:

=HYPERLINK(A2,B2)

The documented expected displays are JOIN help, CONCAT help and ROMAN help, each pointing to its corresponding URL. The destinations were inspected as public documentation, but the cell rendering and click behavior were not tested in a native Sheet.

Keep the plain URL column even when the friendly labels are enough for routine reading. It makes a destination change easier to review and prevents the label from becoming the only visible clue about where a link goes.

Using the URL in A2:

An empty string is not a command to remove the link. For an index intended for other readers, use a meaningful label instead of creating an invisible destination. A genuinely empty cell and a formula returning "" should not be casually treated as the same case; only the distinctions above are explicitly documented.

Enter article IDs 3094077, 3093592, 3094153 in E2:E4 and labels JOIN, CONCAT, ROMAN in F2:F4. In G2, enter and fill down:

=HYPERLINK("https://support.google.com/docs/answer/"&E2,F2&" reference")

Expected labels are JOIN reference, CONCAT reference, ROMAN reference. The expected destination strings match the three URLs in the first table. This example constructs known public reference URLs; it does not discover valid article IDs.

For your own index, keep any base address in a controlled cell and review it when the destination system changes. A correctly assembled URL can still point to a removed or restricted page. Formula construction is only one part of link maintenance.

Google lists HTTP, HTTPS, mailto, AIM, FTP, Gopher, Telnet and news as permitted schemes. An unsupported scheme leaves the label as text rather than a hyperlink. A protocol’s presence on this list does not guarantee that a browser has a usable handler for it.

The reference documents error propagation when the URL expression is an error. It also warns about unquoted literals. Cell references, however, are meant to be passed without quotation marks: A2 refers to the value; "A2" is literal text.

For a label that is not clickable, check the destination scheme and URL expression. For a link that opens an access error, inspect the destination’s permissions separately. HYPERLINK does not grant document access or prove the page is trustworthy.

This function creates a cell link; it is not a web-content importer or a link-health test. Do not describe a valid-looking label as proof that its destination exists or that a recipient can open it. Avoid placing secrets or private identifiers in constructed URLs unless the receiving service and sharing context are appropriate.

HYPERLINK is documented for the rolling Google Sheets service. Original introduction date, first version and last functioning numbered release were not established. No blanket portability claim is made for alternate protocols or empty-label behavior in another application.

NOT_TESTED_IN_GOOGLE_SHEETS. Google’s individual HYPERLINK page and the example help destinations were inspected on October 17, 2026. URL and label strings were independently assembled; interactive rendering and clicking are documentation-based expectations only. No screenshot or native session is claimed.

Related published guides: CONCATENATE, IF and TEXT.