Easily Make a Google Sheets Hyperlink (3 Simple Ways)

Google Sheets Hyperlink Explained

A hyperlink lets you quickly access an external webpage or a file/folder in your system. These are widely used in web pages to link to other sites.

You can also create hyperlinks in Google Sheets so that when you click on them, it will take you to that specific web page. You’ll find this helpful if you want to reference a website or after using IMPORTFEED to get data from it.

In this tutorial, I’ll show you how to make a hyperlink in Google Sheets and some cool things you can do with it.

The Quickest Way to Add a Hyperlink in Google Sheets

  1. Highlight the text you wish to add a hyperlink to
  2. Press Ctrl + K (Cmd + K on macOS)
  3. Type or paste the link into the pop-up window

Why Learn How to Hyperlink in Google Sheets?

Hyperlinking is an essential part of creating intricate and massive spreadsheets. It’s an essential skill to learn to move from a basic user to a power user. You can use them as part of dashboards in Google Sheets. Or even just to link to a relevant web page or another sheet. If you’d like to learn more about how it could help you, we’d recommend taking a comprehensive course and seeing just how much it comes up. One of your favorites is the one below.

The Complete Google Sheets Course: Beginner to Advanced!

Add an Automatic Hyperlink in Google

Sometimes when you type a URL into a cell, Google Sheets automatically converts them to hyperlinks. For example, if you type Google.com in a cell and click enter, it will automatically become a clickable link.

This also works when you paste the URL directly into the cell. Google Sheets automatically converts it to a clickable hyperlink.

However, this method does not add a label and works with the entire URL itself. If you want to add a link to an existing text, read on to learn how to link in Google Sheets.

How to Add Hyperlinks in Google Sheets

There are three ways to add hyperlinks in Google Sheets:

  • Using the Ctrl + K keyboard shortcut (discussed above)
  • Using the ‘Insert Menu’
  • Using the hyperlink button
  • Using the Hyperlink formula.

Let’s have a look at all these methods for how to hyperlink in Google Sheets.

Insert Hyperlinks Using the ‘Insert Menu’

Suppose you have a dataset, as shown below, where you want to add hyperlinks to the homepages of these companies:

Companies without hyperlinked names

Here are the steps for how to create a hyperlink in Google Sheets to each of these names:

  1. Select the cell in which you want to insert the hyperlink.
  2. Go to the ‘Insert’ Tab.
  3. Click on the ‘Link’ option.
Go to Insert > Link
  1. In the dialog box that opens, enter the URL of the link.
    In the dialog box that opens, enter the URL of the link.
  2. Click Apply.

This will insert the hyperlink into the cell. Now when you hover the mouse over the cell, it will show you the link on which you can click and visit the web page (which opens in a new tab).

NOTE: You can also use the keyboard shortcut – Control + K or Command + K for Mac to insert a hyperlink in Google Sheets. As soon as you use this shortcut, it will open the ‘Insert Link’ dialog box.

Insert a Hyperlink Using the Hyperlink Button

You can also use the hyperlink button, a shortcut to the hyperlink menu in the Insert tab. You’ll find this button on the Quick access toolbar.

Here’s how to insert a link in Google Sheets with the hyperlink button:

  1. Select the text
  2. Click on the hyperlink button
  3. In the hyperlink window, type or paste the link in the link box
  4. Click Apply or Enter

Insert Hyperlinks Using the HYPERLINK Formula in Google Sheets

Another good Google Sheet trick to insert hyperlinks is to use the HYPERLINK Google Sheets formula. The formula is a simple one with only two arguments for the Google Sheets URL and the label.

Let me quickly cover the syntax of the HYPERLINK function:

HYPERLINK(URL, LINK_LABEL)

  • URL – this is the URL that you want to insert as the hyperlink. You need to specify the full URL and need to enclose it within double quotes.
  • LINK_LABEL – this is the text that you would see in the cell. You need to specify the text in double quotation marks.

Here is the formula that will insert the hyperlink of the Google homepage with ‘Google’ as the link label.

=HYPERLINK("https://www.Google.com","Google")
Hyperlinks in Google Sheets - hyperlink formula

When you hover the mouse over the cell with the hyperlink, it will show you the link on which you can click. When you click on it, it will take you to that web page.

The Google Sheets hyperlink function is particular about the link types you can use. The allowed link types include HTTP, HTTPS, news, aim, FTP, gopher, telnet, and mailto. Any other link type will not result in a hyperlink, and you will be left with only the label in the cell.

Creating a Hyperlink to Another Sheet in the Same Google Sheets Document

Using this insert link method, you can easily create a hyperlink to another sheet in the same Google Sheets document.

Here are the steps:

  1. Select the cell in which you want to insert the hyperlink.
  2. Go to the Insert Tab.
  3. Click on the ‘Link’ option.
  4. You may get a suggestion for the sheet link. If you don’t, click on the ‘Sheets and named ranges‘ option.
You may get a suggestion for the sheet link. In case you don’t, click on the 'Sheets and named ranges' option.
  1. Select the sheet for which you want to create the hyperlink.
Select the sheet for which you want to create the hyperlink.
  1. Click Apply.

When you click on the hyperlink text, it will automatically take you to the specified sheet.

You can also use the HYPERLINK function to create a hyperlink to another sheet. If you pay attention to the URL and switch between sheets, you will notice that the URL slightly changes, This is because each sheet in Google Sheets has its own unique URL.

To use the hyperlink function:

  1. Go to the second sheet and select its URL
  2. Click Ctrl+C or Cmd+C for mac to copy it
  3. Go to the first sheet and click on a cell
  4. Type in the HYPERLINK formula
  5. Paste the URL in the formula and enclose it in quotation marks
  6. Add the label you want to use
using the HYPERLINK function to create a hyperlink to another sheet

The link you get should take you to the other sheet if you click it.

Creating a Hyperlink to a Range of Cells in Google Sheets

You can also use the same technique shown so far to create a hyperlink to a range of cells in the same or a different sheet. These can be useful if you have a table of content in your Google Sheet.

Here are the steps:

  1. Click the cell in which you want to insert the hyperlink.
  2. Go to the Insert Tab.
  3. Click on the ‘Link‘ option.
  4. In the dialog box, click on the ‘Select a range of cells to link‘ option.
  5. Specify the range.
  6. Click Apply.

You can also use the HYPERLINK function to link to a range of cells by getting the link to the cell range. Here’s how:

  1. Select the range of cells you want to link to
  2. Right-click and go to View more cell actions
  3. Select Get link to this range. The URL will be copied to your clipboard.
  4. Choose the cell you to put the link in
  5. Type the HYPERLINK formula
  6. Paste the URL into the formula and enclose it in quotation marks
  7. Add the label for the link

With this method, you should get the same results: a link that takes you to the range of cells specified. You may need to add quotation marks correctly if you get an error.

How to Add Multiple Hyperlinks

You can add more than one hyperlink in a cell in Google Sheets as long as you have more than one value in the cell.

Here are the steps:

  1. Click the cell you want to add hyperlinks in
  2. In the formula tab (fx), select the first text
  3. Click Ctrl+K or Cmd+K for mac
  4. Copy and paste or type the link in the window that appears
  5. Click Apply or Enter
  6. Select the second text in the formula tab and repeat the process

How to Edit a Google Sheets Hyperlink

If you want to edit the hyperlink, that is also possible in Google Sheets. To edit a Google Sheet hyperlink:

  1. Click on the link or hover the mouse over the link
  2. Click on the pencil icon, which is the edit icon.
edit a hyperlink in Google Sheets
  1. In the hyperlink window, you can change the label or the link. You can also select a range of sheets to add the hyperlink to.
  2. Once you are done editing, click Apply or Enter.

You can also access the Edit link option in the Insert tab.

FAQs on How to Create Hyperlinks in Google Sheets

Can You Hyperlink a Tab in Google Sheets?

You can link to a tab in Google Sheets so that when you click the link, it will automatically take you to that tab.

How to Convert Non-clickable Links Into Clickable in Google Sheets?

Sometimes Google fails to hyperlink a link automatically, and you may ask yourself, how do I make a clickable link in Google Sheets? You’ll need to insert hyperlinks to convert non-clickable links to clickable in Google Sheets.

You can use the hyperlink function in Google Sheets or the link option in the Insert tab. All you need to do is select the non-clickable link and press CTRL+C or CMD+C for mac to copy it. Then click the hyperlink button and paste it into the link box and click enter. The link should be clickable.

How to Hyperlink Part of the Text in Google Sheets?

Google Sheets now allows you to specify multiple hyperlinks in a single cell. This means you can now link portions of text or add multiple links in a single cell. Simply select the part of the text that you want to hyperlink and click on the ‘Insert link’ icon or CTRL+K from the keyboard. If you’re on a Mac, press Cmd+K instead. You can then specify the location that you want the text to link to.

How to Hyperlink to Another Sheet in Google Sheets?

To hyperlink to another sheet within the same document, follow the steps shown above in the section “Creating a Hyperlink to a Sheet in the Same Google Sheets Document” of this tutorial.

How Do You Do Dynamic Hyperlinks in Google Sheets?

If you want to generate a hyperlink based on a cell reference dynamically, you can use the   Google Sheets HYPERLINK formula as explained here and specify the reference to the cell containing your hyperlink in the first parameter. So if cell A2 contains the dynamic location for your hyperlink, simply use the HYPERLINK formula as shown below:

=HYPERLINK(A2, LINK_LABEL)

Here, replace the LINK_LABEL parameter with the text you want to display as your hyperlink.

If you want to add a value in a given cell to an existing hyperlink, simply add the cell reference with an ampersand (&) to the URL string. For example, in the image below, cell A2 contains a number that you want to add to the end of the URL “www.example.com/”. So your HYPERLINK formula can be:

=HYPERLINK(“www.example.com/”&A2, LINK_LABEL)

This will link to the location “www.example.com/123”

Final Thoughts

In this article, we have shown you three ways to add a Google Sheets hyperlink to your sheet. We have also shown you other hyperlink functionalities in Google Sheets, such as how to link to another sheet and how to link to a range of cells.

If you found this tutorial useful, be sure to check out our other articles, like how to create and use filter views in Google Sheets.

Sumit
Spreadsheet Expert at Productivity Spot | + posts

Sumit is a Google Sheets and Microsoft Excel Expert. He provides spreadsheet training to corporates and has been awarded the prestigious Excel MVP award by Microsoft for his contributions in sharing his Excel knowledge and helping people.

Popular Posts

2 thoughts on “Easily Make a Google Sheets Hyperlink (3 Simple Ways)”

Comments are closed.

You May Also Like