How to Use the HYPERLINK Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: HYPERLINK puts a clickable link in a cell. The formula is =HYPERLINK(url, [link_label]). The label is the text shown, and it defaults to the URL.

What HYPERLINK does

HYPERLINK builds a link from a formula, so the address and the label can come from other cells. That is useful for a contact list with one link per row, or a report where the link is assembled from an ID. Per Google, Sheets already converts most valid URLs typed directly into a cell, so the function is not always needed.

HYPERLINK syntax

=HYPERLINK(url, [link_label])

If the URL evaluates to an error, the function returns an error. Forgetting the quotation marks around the URL or label also causes an error.

A step-by-step example

=HYPERLINK("https://www.google.com", "Google")

This shows the word Google as a clickable link to that address.

Build links from cells

Here a URL is in A2 and its label is in B2.

AB
1URLLabel
2https://example.comExample site
=HYPERLINK(A2, B2)

This shows Example site as a link to the address in A2. Fill it down to link every row. To glue a base address and an ID together, use CONCATENATE or the ampersand for the URL.

Common mistakes

Try it yourself

Use the cells above (A2 and B2). Type your formula into the box, starting with =, then press Check.

Exercise 1: A labeled link

Write a formula that shows the text Google as a link to https://www.google.com.

Hint: URL first, then the label, both in quotation marks.

Exercise 2: Link from cells

Write a formula that makes a link using the URL in A2 and the label in B2.

Hint: use cell references with no quotation marks.

What to learn next

Syntax and rules in this guide were checked against Google's HYPERLINK help page. See all guides.