Google Sheets Hyperlink: How to Add Links in Your Spreadsheet

Published: February 10, 2024 - 5 min read

Julian Alvarado

Hyperlinks in Google Sheets boost efficiency by linking to other sheets, ranges, or external sites. 

This guide simplifies hyperlink creation, editing, and advanced techniques, tailored for B2B SaaS operations teams.

There are several ways to create hyperlinks in Google Sheets, including using the Insert menu, the HYPERLINK function, or by manually entering the link into a cell. Each method has its own advantages and disadvantages, and the best approach will depend on your specific needs. 

Additionally, it’s important to know how to edit and delete hyperlinks, as well as how to troubleshoot common issues that may arise. 

In this section, we will discuss how to insert, edit, and remove hyperlinks in Google Sheets.

To insert a hyperlink in Google Sheets, follow these steps:

  1. Select the cell where you want to insert the hyperlink.
  2. Click on the “Insert” menu and select “Link” or use the keyboard shortcut “Ctrl + K”.
  3. In the “Link” dialog box, enter the URL of the website or the cell reference of the sheet or range you want to link to.
  4. Click “Apply” to create the hyperlink.

Alternatively, you can also use the “HYPERLINK” formula to create a hyperlink. The formula syntax is as follows:

=HYPERLINK(url, [link_label])

Where “url” is the URL or cell reference and “link_label” is the text you want to display as the hyperlink.

To edit a hyperlink in Google Sheets, follow these steps:

  1. Click on the cell containing the hyperlink you want to edit.
  2. Click on the “Edit” button in the formula bar or right-click on the cell and select “Edit link”.
  3. In the “Link” dialog box, edit the URL or cell reference as needed.
  4. Click “Apply” to save the changes.

To remove a hyperlink in Google Sheets, follow these steps:

  1. Click on the cell containing the hyperlink you want to remove.
  2. Click on the “Edit” button in the formula bar or right-click on the cell and select “Remove link”.
  3. The hyperlink will be removed, and the text will remain in the cell.

Google Sheets offers several advanced hyperlink techniques that can help users create more complex and powerful spreadsheets. 

In this section, we will explore some of the most useful techniques for creating advanced hyperlinks in Google Sheets.

One of the most powerful features of Google Sheets is the HYPERLINK function. This function allows users to create dynamic hyperlinks that can be updated automatically based on changes to the underlying data. 

To use the HYPERLINK function, simply enter the URL or cell reference that you want to link to, along with the display text for the hyperlink, inside the function. For example:

=HYPERLINK(“https://www.example.com”, “Click Here”)

This will create a hyperlink with the display text “Click Here” that links to the URL “https://www.example.com“. The HYPERLINK function can also be used to create hyperlinks that link to other sheets within the same spreadsheet, or even to other spreadsheets altogether.

Linking to Different Google Sheets

Google Sheets also allows users to create hyperlinks that link to different sheets within the same spreadsheet, or even to other spreadsheets altogether. 

To create a hyperlink that links to a different sheet within the same spreadsheet, simply enter the sheet name followed by an exclamation point (!), and then the cell reference that you want to link to. For example:

=HYPERLINK(“#’Sheet2′!A1”, “Click Here”)

This will create a hyperlink with the display text “Click Here” that links to cell A1 on Sheet2 within the same spreadsheet. 

To create a hyperlink that links to a different spreadsheet altogether, simply enter the URL of the other spreadsheet followed by the sheet name and cell reference that you want to link to. For example:

Coefficient Excel Google Sheets Connectors
Try the Free Spreadsheet Extension Over 314,000 Pros Are Raving About

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

Get Started

=HYPERLINK(“https://docs.google.com/spreadsheets/d/123abc456def/edit#gid=0&range=A1”, “Click Here”)

This will create a hyperlink with the display text “Click Here” that links to cell A1 on the first sheet of the spreadsheet located at the URL “https://docs.google.com/spreadsheets/d/123abc456def/edit“.

Hyperlinking with Scripts

Finally, Google Sheets also allows users to create hyperlinks that are triggered by scripts. This can be useful for creating dynamic and interactive spreadsheets that respond to user input. 

To create a script-triggered hyperlink, simply create a custom menu or button that runs a script when clicked. For example, you could create a button that opens a specific URL when clicked, like this:

function openUrl() {

  var url = “https://www.example.com”;

  var html = “<script>window.open(‘” + url + “‘);</script>”;

  var userInterface = HtmlService.createHtmlOutput(html);

  SpreadsheetApp.getUi().showModalDialog(userInterface, “Opening URL”);

}

This script will create a button that, when clicked, opens the URL “https://www.example.com” in a new window. You can customize the script to perform any action that you want, such as updating data in the spreadsheet or sending an email.

Conclusion

In summary, mastering hyperlinks in Google Sheets streamlines navigation and access to critical data, enhancing productivity for SaaS operations teams.

Ready to amplify your Google Sheets capabilities?

Embark on your journey with Coefficient for seamless data integration and advanced features.

Set Spreadsheet Data on Refresh

Try the Spreadsheet Automation Tool Over 300,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 300,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
Google icon
300,000+ users on Google Marketplace
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies