Easily Make a Google Sheets Hyperlink (3 Simple Ways)

By

Let’s discuss how to make a Google Sheets hyperlink. You might want to do this to help viewers quickly find more information about a topic, access a relevant file, or to cite your data sources. This article gives step-by-step instructions on Google Sheets hyperlinks.

Before we dive in, let’s discuss one more common usage. 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.

Below, I will show you how to make a hyperlink in Google Sheets (and some helpful things you can do with it).

The Quickest Way to Add a Hyperlink in Google Sheets

There are three simple ways to add a hyperlink to Google Sheets. The first happens automatically. If you enter a URL (or what looks like a URL), you just have to hit enter. Then, the Google Sheets hyperlink appears automatically. Here’s how that looks:

The second is with keyboard commands. Here’s how to do it:

  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

The other easy way to hyperlink in Google Sheets uses your mouse. First, copy your desired URL (or file location). Then, highlight your cell (or the text within the cell), right click, and select “insert link”. Here’s a short video that shows how to do it.

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. We evaluated all the most popular Google Sheets courses. Most start with the basics (including how to hyperlink in Google sheets) before moving on to more advanced formulas and add-ons.

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. That’s what happened in the video above.

This also works when you paste the URL directly into the cell. Google Sheets automatically converts it to a clickable hyperlink. Note that this also applies to text Google Sheets interprets as a hyperlink. To remove a hyperlink in Google Sheets, just hover over the hyperlink and click the broken link button. That removes the link.

Note that the automatic Google Sheets hyperlink method doesn’t work in every situation. Here’s an example: 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 several 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 shortcutControl + 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. It’s a super-common way to add a hyperlink to a single cell.

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

The downside to this button is when you need to add multiple hyperlinks in Google Sheets. It still works, but the process takes a while.

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.

As with any formula, this method works well for large amounts of data. That means you can use it to add many links in Google Sheets, all at once.

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. That’s handy for reference, especially when you want to build more complex reports that reference data from a different tab or sehet.

Here’s one common troubleshooting solution: You may need to add quotation marks correctly if you get an error.

How to Add Multiple Hyperlinks

If you want to add multiple links in Google Sheets, you’re in luck. Just make sure the cell contains enough information for more than one link. 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. We covered adding multiple hyperlinks, common troubleshooting, and step-by-step instructions for adding hyperlinks in Google Sheets.

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.

Popular Posts

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

Comments are closed.