How to Insert a Hyperlink in Google Sheets in 5 Seconds

Adding a hyperlink in Google Sheets is a piece of cake. In this article, we will show you how to do it using three different methods, as well as how to modify and delete hyperlinks. Keep reading to find out more.

How to Hyperlink in Google Sheets using the Insert menu

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

1. Click on the cell where you want to add a link.
   

2. Click on the Insert button in the top bar. This will open a dropdown menu.

3. Click on Link. This will open a small window next to the cell where you want to add the Google Sheets link.
   

4. Select an existing link from the list or enter a URL in the Search or paste a link text box.

5. Once you have finished adding the link in the text box, click the blue Apply button.

How to Add a Hyperlink in Google Sheets using right-click

This method works similarly to the previous method. Here are the steps to do it in your spreadsheet:

1. Right-click on the cell where you want to add the hyperlink. This will open a dropdown menu.

2. At the bottom, click on Insert link. This will show you a small popup 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 have finished adding the link in the text box, click the blue Apply button.

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

How to Create Hyperlinks in Google Sheets using a formula

There is another way to add a Google Sheets hyperlink to a cell in your spreadsheet. You can do this using the HYPERLINK formula in Google Sheets. Before learning how to do it in your sheet, let’s review the syntax of the formula itself. Here is the syntax of the formula 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 want to add. It can be either the link itself or the location of a cell containing the link.
• label: This parameter sets the text you want to display in the cell. As it is an optional parameter, it can also be left blank, in which case it will default to the link parameter.

Here are some points to note about the HYPERLINK formula:

1. The formula only allows certain types of links. 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 will not be applied to the cell. This means that only the text will be displayed.

2. If no URL protocol is specified, then the function will default to http://.

3. If the label parameter refers to an empty cell, the link will be displayed as the label parameter or display plain text.

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

1. Click on the cell where you want to enter the formula.
   

2. Enter the first part of the formula, which is =HYPERLINK(.

3. Next, 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, then write the label parameter. In this case, we will write it as “Google” including the quotation marks.

5. Finally, add the closing parentheses and press the Enter key to execute the formula.

How to Create Hyperlinks in Google Sheets to another sheet

You can also create links to other sheets in your document using the hyperlink feature. This is very useful if you want to quickly access data in another sheet or within the same spreadsheet. You can create a hyperlink that will take the user to the other worksheet. This is done very simply and follows similar steps to those discussed above.

Here are the steps to create a hyperlink in Google Sheets within the same document:

1. Click on the cell where you want to add a link.
   

2. Click on the Insert button in the top bar. This will open a dropdown menu.

3. Click on Link. This will open a small window next to or below the cell where you want to add the Google Sheet link.

4. Select the Sheets and named ranges option at the bottom of the list. This will allow you to add existing sheets or a range of cells.
   

5. Click on the sheet you want to link to. In this case, we want to link to Sheet2.

How to Modify a Hyperlink in Google Sheets

There are several ways to modify a hyperlink in a Google Sheets spreadsheet. Let’s look at all the ways you can do it.

The first way to do it is by clicking on the cell, then clicking the Insert button in the top bar. This will open a dropdown menu. There, click on the Edit link option. This will open a small window that allows you to edit the text and link. Make the necessary changes and click the Apply button.

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

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

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

How to Add Multiple Hyperlinks in Google Sheets

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

1. Click on the cell that contains the sentences you want to add a hyperlink to.
   

2. Now, click and drag the text you want to add the first link to the formula bar.

3. With the text selected, press the keyboard shortcut Ctrl + K (or Cmd + K for macOS) on your keyboard. This will open the window for you to enter the URL.

4. Click the Apply button after entering the link.

5. Now, deselect the text and click and drag over the other text.

6. Press the keyboard shortcut Ctrl + K 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 on the cell where you want to add a link. Click on the Insert button in the top bar. This will open a dropdown menu. There, click on Link. This will open a small window next to the cell where you want to add the Google Sheets link. Here, select the Sheets and named ranges option at the bottom of the list. This will allow you to 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 on the cell where you want to add a link.

2. Click on the Insert button in the top bar. This will open a dropdown menu.

3. Click on Link. This will open a small window next to the cell where you want to add the Google Sheets link.

4. Select an existing link from the list or enter a URL in the Search or paste a link text box.

5. Click the Apply button.

How do I add multiple hyperlinks in the same cell in Google Sheets?

1. Select the specific text in the cell where you want to add hyperlinks in the formula bar.

2. Press Ctrl + K or Cmd + K.

3. Enter the URL in the popup dialog and click Apply.

4. Repeat for the other texts you want to add additional hyperlinks to.

What is the keyboard shortcut for hyperlinks in Google Sheets?

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

Conclusion

Now that you know how to add a hyperlink in Google Sheets using the Ctrl + K (Cmd + K) keyboard shortcut, the Insert menu, or the HYPERLINK function, you have many options. Let us know in the comments if you have any difficulties with something discussed in this article.

For more tips and tricks on Google Sheets and other Google tools, visit Crawlan.com – your go-to source for all things Google Sheets!