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:

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

=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.

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 500,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 350,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.
500,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 50,000 Companies