How to Add Links to Google Sheets

Overview

This tutorial will guide you through how to add links to your Google Sheet.

  • You will need to be logged in to your Google account

Related Guides

  • No related guides available

Steps

Method One

  1. Open your Google Sheets document.
  2. Select the cell where you want the hyperlink to appear.
  3. In the formula bar, enter the following formula

   =HYPERLINK("URL", "Link Text")

  1. Replace:
    1.  URL:  with the web address you want to link to
    2.  Link Text:  with the clickable text you want displayed
    3. Example:  =HYPERLINK("http://www.edmonds.edu/", "Edmonds College Home Page")
  2. Press Enter to apply the hyperlink.
  3. Note: To remove the hyperlink, click the cell and delete the formula from the formula bar.

Method Two

  1. Open your Google Sheets document.
  2. Select the cell where you want to insert the hyperlink.
  3. Click the Insert link button in the top menu, or right-click the cell and choose Insert Link
  4. Enter the text you want displayed in the cell and paste or type the URL into the Link field.
  5. Click Apply to create the hyperlink. Note: To remove the link, simply delete the syntax from the formula bar. If you remove the hyperlink by selecting “Remove,” the text will be left in the formula bar. 
  6. Success! You have successfully added the link

​

Last Updated: September 21, 2026