Google Sheets Hyperlink: Everything You Need to Know in 2023

In this article, we will discuss how to create hyperlinks in Google Sheets using different methods such as the “Insert Link” option, the HYPERLINK formula, and the right-click method. Follow the step-by-step instructions below to add hyperlinks to your Google Sheets.

Create a Hyperlink Using the “Insert Link” Option

1. Select the Cell for the Hyperlink

First, choose the cell where you want to insert the hyperlink. For example, we have selected cell A1.

2. Open the “Insert Link” Box

In the file menu at the top of the page, click on Insert and then select Link. This will open the insert hyperlink box.

3. Input the Display Text

In the box labeled Text, enter the text that you want to be displayed in the cell. For instance, let’s use “Lido Website” as our display text.

4. Paste or Type the URL

In the URL box, paste or type the website URL that you want to hyperlink. Ensure that you input a valid website URL. For example, we will use the URL https://www.lido.app/.

5. Apply the Hyperlink

Click on Apply to create the hyperlink. Now you will have a cell containing a clickable hyperlink with the specified display text.

Insert a Hyperlink Using the HYPERLINK Formula

1. Select the Target Cell

Choose the cell where you want the hyperlink to appear. Let’s use cell A1 as an example.

2. Use the HYPERLINK Formula

In the cell, use the formula =HYPERLINK(“link”,”text”). Replace “link” with the desired URL and “text” with the text you want to display as the hyperlink.

Formula Breakdown:

• Link: Input your desired URL.
• Text: This is the text that appears as the hyperlink.

Remember to enclose the URL and text in quotation marks. Forgetting to do so will result in error prompts. For instance, you can use the formula =HYPERLINK(“https://www.lido.app/”,”Lido“) to create a hyperlink with the display text “Lido.”

3. View Your Hyperlink

Press Enter to see the hyperlink in action. You will now have a clickable hyperlink that directs to the specified URL.

Add a Hyperlink Using the Right-Click Method

1. Right-Click on the Target Cell

Simply right-click on the cell where you want to add the hyperlink.

2. Select “Insert Link”

From the right-click menu, choose the option Insert Link.

3. Enter the Text and Link

Type in the desired text and URL for the hyperlink. For example, let’s use “Lido” as the display text and “https://www.lido.app/” as the URL.

4. Press Enter

Once you’ve entered the text and link, press Enter. Your hyperlink will now be available in the selected cell.

How to Hyperlink to Another Sheet

If you want to create a hyperlink within your spreadsheet to quickly navigate between sheets, follow this guide:

1. Click on “Insert” and Select “Link”

On a blank cell, click on Insert from the main menu, and then select Link.

2. Choose “Sheets and Named Ranges”

In the pop-up menu, click on Sheets and Named Ranges.

3. Select the Target Sheet

Choose the sheet to which you want to add the hyperlink. For example, let’s create a hyperlink to the Cash Flow Sheet. Simply click on the sheet name in the list.

4. Create the Hyperlink

Now you have a hyperlink that allows you to navigate to another sheet within the same workbook. This is especially useful for larger or related sheets, eliminating the need to scroll through the list of visible sheets.

In conclusion, these are the different methods you can use to add hyperlinks to cells in Google Sheets. If you need more assistance with Google Sheets or other topics, visit Mr Reviews for helpful guides and resources.

Other Google Sheets Formatting Articles

• How to Use People Chips in Google Sheets
• How to Strikethrough in Google Sheets
• How to Remove Gridlines in Google Sheets
• How to Underline in Google Sheets
• How to Add Bullet Points in Google Sheets
• How to Indent in Google Sheets
• Google Sheets Dark Mode
• Add Line Break in Google Sheets
• Word Count in Google Sheets
• Color Every Other Row in Google Sheets