Enter links in Google Sheets

If you want to include a link in your spreadsheet, simply enter the URL in the cell. For example you can enter: “www.google.com.”

Linking text

If you want to link a specific URL to text within a cell of your spreadsheet, you can insert a HYPERLINK formula into the desired cell. For example:

=HYPERLINK(“www.google.com”, “Google”)

In this example, the word “Google” would appear in the spreadsheet and be linked to www.google.com.

Other linking options

If you have opted into the new Google Sheets, you have several ways to insert links. You can tell that you are using the new Sheets if you see “New Google Sheets” in the bottom right corner of your spreadsheet.

  1. Find and open your spreadsheet.
  2. Click the cell in your spreadsheet where you'd like the link to appear.
  3. Choose from the following options:
    • Click the "Insert" drop-down menu and select Link.
    • Click the link icon in the toolbar.
    • Right click in your spreadsheet and select the Insert link option.
    • Use the Ctrl + K keyboard shortcut (Cmd + K on a Mac).
  4. In the "Text" field that appears, type or edit the text you'd like displayed in the cell containing the link. Leave this field blank if you want the full URL to be displayed in your spreadsheet.
  5. In the “Link” field, you can either paste a URL or email address, or type in the field to begin a search of relevant links across web content and your Google Drive files. You can also click Find more below the search results to browse additional options.
  6. Click Apply.
At the moment, you can’t enter formulas or cell references into the link creation tool. However, if you want to create a link using formulas, use the HYPERLINK function.

Remove a hyperlink

  1. Find and open your spreadsheet.
  2. Click the cell in your spreadsheet with the URL you’d like to remove.
  3. Right-click in the cell and choose Remove link in the menu that appears.

If you want to add the hyperlink again, right-click the cell and select Show hyperlinks.