If you want a cell to show friendly text but still click through to a web address, the HYPERLINK function in Google Sheets does exactly that.
You give it a URL and a label, and it builds a clickable link that displays the label instead of the long address. In this article I’ll show you how to use it with four practical examples.
HYPERLINK Function Syntax in Google Sheets
Here is how you write the HYPERLINK function.
=HYPERLINK(url, [label])
- url – the full web address to link to, in quotes or pulled from a cell. It needs the
https://part to work. - label – optional. The text the cell displays. Leave it out and the cell shows the raw URL instead.
When to Use HYPERLINK Function
- Show a clean, readable label in a cell instead of a long messy URL.
- Build links from data you already have, like a list of page names or slugs.
- Turn a column of search terms into ready-to-click search links.
- Keep a directory of resources where each row links straight to its source.
Example 1: Basic Clickable Link With Custom Label Text
Let’s start with the simplest case, one fixed URL with a readable label.
Below is the dataset, a single column of label text in A2 to A5.
The goal is to make each cell a clickable link that shows the label but points to a help page.
Here is the formula:
=HYPERLINK("https://support.google.com/docs",A2)
The first argument is the address to open, and the second is the text the cell shows. So the cell displays Google Sheets Help while quietly linking to the support page.
Click the cell and it opens the URL. The label is just what you see, which keeps the sheet tidy instead of cluttered with long links.
Pro Tip: Skip the second argument and the cell shows the raw URL instead, like =HYPERLINK("https://support.google.com/docs"). Handy when the address itself is short enough to read.
Example 2: Pull the URL and Label From Two Columns
Most of the time your URLs and labels live in their own columns.
Below is the dataset, with the display Label in column A and the matching URL in column B, across rows 2 to 5.
The goal is to combine each pair into one clickable link in column C.
Here is the formula:
=HYPERLINK(B2,A2)
This time both arguments are cell references. B2 holds the address and A2 holds the label, so the cell shows GeoSheets and links to its site.
Keeping the URL and label in separate columns makes a list easy to maintain. Update either column and the link updates with it.
Example 3: Build the Link by Joining a Base and a Page
You can assemble the URL on the fly with a little text joining.
Below is the dataset, a single column of page slugs in A2 to A6.
The goal is to attach each slug to a fixed base URL and show the slug as the label.
Here is the formula:
=HYPERLINK("https://example.com/"&A2,A2)
The & joins the base address to the slug in A2, so the first row builds a link to example.com/functions. The label stays as the plain slug.
This pattern saves a ton of typing when every link shares the same base. You only store the part that changes and let the formula handle the rest.
Example 4: Turn a Search Term Into a Google Search Link
Here is a fun one, building search links from a list of topics.
Below is the dataset, a column of search topics in A2 to A5.
The goal is to wrap each topic in a Google search URL while showing the plain topic as the label.
Here is the formula:
=HYPERLINK("https://www.google.com/search?q="&A2,A2)
The search URL ends with q=, and joining the topic after it sends that term straight to Google. Clicking the first row runs a search for weekday function.
The label still shows just the topic, so the column reads like a clean list of links. Spaces in the term are handled by Google’s search page when you click through.
Tips & Common Mistakes
- Include the full
https://in the URL. Without the protocol, Google Sheets treats it as plain text and the link won’t open. - The label is only what shows in the cell. The clickable destination is always the first argument, so check that the URL is correct, not just the label.
- If you build the URL by joining text, watch your quotes and the
&. A missing quote is the most common reason a HYPERLINK formula returns an error.
HYPERLINK keeps your sheets clean by hiding long addresses behind readable labels. Whether you point at a fixed page or build links from your own columns, the click always lands where you set it.
Try it on a list you already have and watch a column of plain text turn into a set of working links.