How to Add Links to Google Sheets

Before You Begin

This tutorial will guide you through how to add links to your Google Sheet.  You can also follow along through the accessible photo guide here: How to Add Links to Google Sheets

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