How to Insert a Google Sheets Hyperlink in 5 Seconds

Adding a Google Sheets hyperlink is a piece of cake. This guide will show you how to do it with 3 different methods as well as how to edit and delete hyperlinks. Read on to learn more.

How to Hyperlink on Google Sheets Using Insert Menu

This method is a simple way to add a Google Sheets hyperlink button to the spreadsheet. In this example, we wish to add the Google web address to the text. Here are the steps you need to follow to add a Google Sheets URL to a spreadsheet:

  1. Click the cell where you wish to add a link.

  1. Click the Insert button in the main top bar. This will open a drop-down menu.
  2. There, click on Link. This will open a small window beside the cell where you want to add the Google Sheet link.

  1. Here, select a pre-existing link in the list or write a URL in the Search or paste a link.
  2. Once you’re done adding the link to the textbox, click the blue Apply button.

How to Add a Hyperlink in Google Sheets Using Right-Click

This method works similarly to the previous way. Let’s look at how you can do this in your spreadsheet. Here are the steps you need to follow:

  1. Right-click the cell where you wish to add the hyperlink. This will open a drop-down menu there.
  2. Towards the bottom, click the Insert link button. This will show you a small pop-up window where you can enter the link in the Search or paste a link text box, or select a link from the options below.
  3. Once you’re done adding the link to the textbox, click the blue Apply button.

You can also use the Ctrl+ K (Command + K on macOS) keyboard shortcut, making it the fastest way to create hyperlinks in Google Sheets.

How to Create Hyperlinks in Google Sheets Using a Formula

There’s another way in which you can add a Google Sheet hyperlink to a cell in a cell in your sheet. You can do this using the Google Sheets HYPERLINK formula. Before we look at how you can do this in your sheet, let’s look at the formula itself. Here is the formula’s syntax in Google Sheets:

=HYPERLINK(link , label)

The formula requires two parameters to work. These are:

  • link: this parameter is the URL of the link you wish to add. This can be the link itself or the location of a cell containing the link.
  • label: this parameter defines the text you wish to display in the cell. As this is an optional parameter, it can be left empty, too, where it will default to the link parameter.

Here are a few things to note about the HYPERLINK formula:

  1. The formula only allows some link types. These include https://, mailto:, http://, ftp://, telnet://, news://, gopher://, and aim:. If a different protocol type is used, the label parameter will be displayed, but the link won’t be applied to the cell. This means that only the text will be shown.
  2. If no URL protocol is defined, then the function will use http:// by default.
  3. If the label parameter references an empty cell, the link will display as the label parameter or show plain text.

Now that we know how the formula for hyperlinks in Google Sheets works, let’s look at an example. Here are the steps you need to follow to use HYPERLINK in Google Sheets:

  1. Click the cell where you want to enter the formula.
  2. Enter the starting part of the formula, which is =HYPERLINK(.
  3. Now enter the first parameter, which is the link parameter. In this example, we will write it as “www.Google.com” including the quotation marks.
  4. Add a comma and then write the label parameter. In this case, we write it as “Google” including the quotation marks.
  5. Finally, add closing brackets and press Enter to execute the formula.

How to Hyperlink in Google Sheets to Another Sheet

You can also create links to other sheets in your sheet using the hyperlink feature. This is highly useful if you want to jump to data in another sheet or the same spreadsheet quickly. You can create a hyperlink that will take the user to the other spreadsheet. Doing this is very simple and follows similar steps to the ones discussed above.

Here are the steps you need to follow to hyperlink Google Sheets in the same document:

  1. Click the cell where you wish to add a link.

  1. Click the Insert button in the main top bar. This will open a drop-down menu.
  2. There, click on Link. This will open a small window beside or below the cell where you want to add the Google Sheet link.

  1. Here, select the Sheets and named ranges option at the bottom of the list. This will let you add existing sheets or a range of cells.

  1. Click the sheet you wish to hyperlink. In this case, we want to link Sheet2.

How to Edit a Google Sheets Hyperlink

There are multiple ways in which you can edit a Google spreadsheet link. Let’s take a look at all of how you can do this.

The first way to do this is to click the cell and then click the Insert button in the main top bar. This will open a drop-down menu. There, click the Edit link option. This will open a small window allowing you to change the text and the link. Make the necessary changes and click the Apply button.

The second way to do this is to right-click the cell, which will open a menu. There, click the Edit link option. There you can edit the name and the link and save it.

You can also use the Ctrl+ K (Command + K on macOS) keyboard shortcut, or you can click the cell containing the hyperlink and then click the pencil icon to open the menu.

You can also follow these steps to remove a hyperlink in Google Sheets.

How to Add Multiple Hyperlinks Google Sheets

Google Sheets recently added a new feature that allows you to add multiple hyperlinks in the same cell in the spreadsheet. Here are the steps you need to follow to do this:

  1. Click the cell which contains the phrases you want to add the hyperlink to.
  2. Now, click and drag across the text you want to add the first hyperlink in the fx formula bar text box.
  3. With the text selected, press the Ctrl+ K (Command + K on macOS) shortcut on your keyboard. This will open the window allowing you to enter the URL.
  4. Click the Apply button after entering the link.
  5. Now, deselect the text and click and drag across the other text.
  6. Press the Ctrl+ K shortcut and enter the link.
  7. Press Apply to save the changes.

You can repeat the steps depending on the amount of text in the document.

Frequently Asked Questions

How Do I Link to a Specific Tab in Google Sheets?

To link to a specific range of cells, click the cell where you wish to add a link. Click the Insert button in the main top bar. This will open a drop-down menu. There, click on Link. This will open a small window beside the cell in which you want to add the Google Sheet link. Here, select the Sheets and named ranges option at the bottom of the list. This will let you add existing sheets or a range of cells.

How Do I Create a Shortcut for a Hyperlink in Google Sheets?

To create a shortcut using a hyperlink in your sheet:

  1. Click the cell where you wish to add a link.
  2. Click the Insert button in the main top bar. This will open a drop-down menu.
  3. Click on Link. This will open a small window beside the cell in which you want to add the Google Sheet link.
  4. Select a pre-existing link in the list or write a URL in the Search or paste a link.
  5. Click the blue Apply button.

How Do I Put Multiple Hyperlinks in One Cell in Google Sheets?

  1. Highlight the specific text from the cell you wish to add hyperlinks to in the fx bar.
  2. Press Ctrl + K or Cmd + K
  3. Enter the URL in the pop-up box and press Apply
  4. Repeat for the other text you want to add other hyperlinks to.

What’s the Keyboard Shortcut for Hyperlinks in Google Sheets?

You can use Ctrl + K on Windows to add hyperlinks. If you’re using macOS, use Cmd + K instead.

Wrapping Up

Now you know you can add a Google Sheets hyperlink with the Ctrl + K (Cmd + K) keyboard shortcut, insert menu, or HYPERLINK function, you have plenty of options. Let us know in the comments if you’re having trouble with anything discussed in this article.

Most Popular Posts

Jake Wright

Jake Wright

Jake is a spreadsheet expert and content writer from New Zealand. He has a double Bachelor's Degree in Teaching and has been working in the education industry for over 11 years. His experience makes him adept at breaking down complex topics so that everyone is able to understand.