How to Use HYPERLINK Function in Google Sheets (2 Ways)

Everything is online-based these days. We frequently need to link web pages, publications, and even Google Sheets or Tables—not just for quick access, but also for reliable reference. The HYPERLINK function in Google Sheets makes this functionality easily accessible. You may learn how to make the most of this function with the help of this article.

A Sample of Practice Spreadsheet

You can copy the spreadsheet that we’ve used to prepare this article.

What Is HYPERLINK Function in Google Sheets?

A hyperlink enables easy access to a system file or folder as well as an external website. A lot of websites utilize them to link to other websites. The HYPERLINK function in Google Sheets is helpful for creating hyperlinks within cells.


The HYPERLINK function has the following syntax.

HYPERLINK(URL, [link_label])

Syntax of google sheets hyperlink function


The HYPERLINK function has the following arguments.

Argument Requirement Function
URL Required The full URL of the link location or a reference to a cell.
[link_label] Optional The text is to be displayed as the link in the cell. It is by default the URL.


The formula =HYPERLINK(“”,”Google”), for example, will make the word Google hyperlinked to the web address:

2 Simple Ways to Use the HYPERLINK Function in Google Sheets

It’s not easy to add links using the Google Sheets HYPERLINK function. However, we could perhaps easily use this method depending on our needs and database. For clarification, go through the examples.

1. General Application

In Google Sheets, there are primarily two ways to use the HYPERLINK function. To illustrate each use, we will use a straightforward example.

1.1 Using Full Web Address

Assume we have information about the top clothing brands in the USA. We wish to make their official website instantly accessible from the data table. To make the functionality practical, we’ll take the next few steps.

data for creating hyperlink in google sheets


  • We’ll start by choosing cell E5.
  • Second, we’ll use “=” to type the function name. In this instance,

formulation of hyperlink function

  • We must place the URL inside quotation marks after the first set of parentheses.

how to add url in hyperlink function google sheets

  • Following that, we will use the brand name as the link label for the URL. It is American Giant in this case.

how to add url label using hyperlink function

  • Either press ENTER or close the parentheses. Final formula:
=HYPERLINK("","American Giant")

output from hyperlink function in google sheets

The word American Giant is now underlined and shown as a hyperlink, as can be seen in the image above.

link preview window

The link with its cover image and meta description will now appear automatically if we select cell E5.

1.2 Utilizing Cell Reference

We can simply use the cells to generate a hyperlink because the table already contains the “Link” column. To understand the concept, go over the next few steps.

using cell reference to create hyperlink


  • Select cell E6 first.
  • To generate a hyperlink, we’ll use the formula below.
  • Here, D6 serves as a URL reference and the label for the link is B6.
  • Press ENTER once again to reveal the outcome.

formulation of hyperlink function

As you can see in the image, we can also generate hyperlinks by using cell values in the equation.

result derived from cell reference used in hyperlink function

When we clicked on the cell in this instance as well, a similar preview window popped with the link.

how to create hyperlink in a column

2. Advanced Application

This function allows us to link or connect any cells, tables, or data within the spreadsheet. Within the spreadsheet, there are two scenarios. We’ll discuss each scenario with a roughly equivalent example.

data for linking cells using hyperlink

Take into account that we have data on the leading perfume brands in the USA. In addition, we have information on the best products from each company. They are, however, on a different page or table. In the table, we wish to connect all of them.

2.1 Connecting to a Cell or Range of Cells

The HYPERLINK function allows us to link a single cell or a range of cells within the spreadsheet. Unlike the last procedure, we must first construct a dummy hyperlink. We will then be able to link the cell, a range of cells, or the sheet. Check out the steps below.

a range of cells as a link in google sheets


  • Select the cell to D5 begin.
  • To generate the dummy hyperlink, we’ll use the formula below.
  • In this case, X act as the URL and A is the label of the URL.
  • To complete, press ENTER.

how to create dummy hyperlink in google sheets

  • After that, clicking the link will cause a little window with a white background to emerge.
  • To open the edit menu, select the Edit link option.

edit link option in link preview

  • We will first modify the label in the new window using the Text bar.

how to change url label in google sheets

  • Instead of “A“, we will type “Item List” as the link label in the text box.
  • After that, select “Sheet and named ranges.” It will lead us to a fresh array of information.

sheets and named ranges option

  • We’ll find “Select a range of cells to link” at the bottom of the window. Click it.

how to link a range of cells in google sheets hyperlink function

  • A new window titled “Select data range” will appear.

how to select data range

  • We’ll choose the G2 through I9 cell range.
  • To finish, click OK.

adding cell reference in the hyperlink

Now we’ll get the same result as seen in the image.

final output from hyperlink function after the edit

The reference table will be immediately accessible to us if we click the following link.

2.2 Linking Another Sheet

Assume that another page contains the data for the top product item. Using the procedures from before, we can also incorporate it. However, we can apply some tricks to speed up the process. Check out the steps listed below.

data for connecting another sheet in google sheets


  • We will start by looking at the Data sheet from Another sheet. The product lists are all there, organized by brand.

data sheet

  • We will now select the cells from B2 to D9 here.

how to rename a range of cells

  • Give them a name in the name box from the upper left corner. such as CK in this instance.
  • What we’ve just created is called a named range.

how to edit name using name box in google sheets

  • We will now return to the Top Products column. To access the Edit menu, select cell D5.
  • We’ll choose the Sheets and named ranges option once more.

linking another sheets using hyperlink function

  • A list of the table names will be available. One of them is CK.
  • To finish this work, click CK.

a list of different table names in google sheets

  • After then, we shall see a picture similar to the one below. If we select the cell, it will give a preview of the data source. In this situation, DATA!B2:D9.

final result from hyperlink function

Now that the cells are connected, clicking one of them will send us directly to the item list data table. We can quickly link tables or cells using any of the methods above mentioned before.

example of google sheets hyperlink function


Although the hyperlinking process is simple, there is room for creativity. There are several ways to include a hyperlink, and the link itself can lead to a variety of destinations. This is all there is to know about the HYPERLINK function in Google Sheets. Check our Website, OfficeWheel, for more relevant information.

Ishrak Khan

Ishrak Khan

Ishrak Khan is a writer and urban planner born in Dhaka, Bangladesh, one of the largest mega-cities. He is a professional Content Developer closely working with OfficeWheel. He simply likes to enthrall his readers. He loves Football, Nico Robin, Deserts, and Twix. If you like the post, give him a heart on Instagram.

We will be happy to hear your thoughts

Leave a reply