Skip to content

How to Add a Hyperlink to a Google Sheet

2 minute read

Sheets Blue

If you work in IT, learn how BetterCloud’s Unified SaaS Management platform can help you manage G Suite and other applications. Also, learn how you can 10x your G Suite productivity

Hyperlinking text in Google Sheets has never been easier. In Google Sheets, you can hyperlink your cells in four easy ways.

If making a hyperlink easy wasn’t enough, Google Sheets also handles email addresses very well. If you hyperlink text and use an email address as the link, Google will automatically create a mailto link, which will open up a new compose window with your contact’s address pre-filled when clicked.

From the Google Support Site:

  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:
  4. Click the “Insert” drop-down menu and select Link.
  5. Click the link icon in the toolbar.
  6. Right click in your spreadsheet and select the Insert link option.
  7. Use the Ctrl + K keyboard shortcut (Cmd + K on a Mac).
  8. 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.
  9. 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.
  10. Click Apply.

Hyperlink text in Google Sheets

Sign up for our newsletter