sodcalculator

10 Tech How-To

Add or Remove Hyperlinks in Google Sheets

Guide 10-54253 · Updated · Step by step

Adding hyperlinks in Google Sheets lets you turn any cell into a clickable link to a website, another sheet, or even a specific cell range. You can also remove links when they’re no longer needed. This guide covers both tasks using the menu, the right-click menu, and the HYPERLINK function, so you can choose the method that fits your workflow.

What You’ll Need

  • A Google account and access to Google Sheets (any device with a browser works).
  • A spreadsheet where you have edit permissions (owner or editor).
  • For linking to a website, the full URL (e.g., https://www.example.com).
  • For linking to another sheet or cell, the name of the sheet and the cell reference (e.g., ‘Sheet2’!A1).

Step-by-Step

Adding a Hyperlink to a Website

  1. Open your Google Sheet in a web browser.
  2. Select the cell where you want the hyperlink. Click once on the cell.
  3. Insert the link using one of these methods:
    • Go to the menu: Insert > Link.
    • Right-click the cell and choose Insert link.
    • Use the keyboard shortcut Ctrl+K (Windows) or Cmd+K (Mac).
  4. Enter the URL in the dialog box that appears. You can paste a full link (https://…) or type a search term to find a page.
  5. Click Apply. The cell text will turn blue and underlined, indicating it’s now clickable.

Adding a Hyperlink to Another Sheet or Cell

  1. Select the cell where you want the link.
  2. Open the link dialog using Insert > Link, right-click > Insert link, or Ctrl/Cmd+K.
  3. In the dialog, click Sheets and named ranges (on the left side).
  4. Choose a sheet from the list, or click Select a range to pick a specific cell or range. You can also type a reference like 'Sheet2'!A1 directly in the text box.
  5. Click Apply. The link will jump to that location when clicked.

Adding a Hyperlink Using the HYPERLINK Function

  1. Select the cell where you want the formula.
  2. Type the formula in the cell or formula bar: =HYPERLINK("https://www.example.com", "Click here"). Replace the URL and display text as needed.
  3. Press Enter. The cell will show the display text and be clickable.
  4. For a link to another sheet, use: =HYPERLINK("#gid=0", "Go to Sheet1") (replace the gid with your sheet’s ID, or use the sheet name in the format #gid=123456).

Removing a Hyperlink

  1. Select the cell(s) containing the hyperlink you want to remove.
  2. Right-click the selected cell(s).
  3. Choose Remove link from the context menu. The link is removed, but the text remains.
  4. Alternatively, use Insert > Link (or Ctrl/Cmd+K), then click the Remove button in the dialog.
  5. If you used the HYPERLINK function, simply delete the formula from the cell or replace it with plain text.

Common Mistakes

  • Forgetting the “https://” prefix: Google Sheets often adds it automatically, but if you type “www.example.com” without the protocol, the link may not work when clicked.
  • Linking to the wrong sheet: When using the “Sheets and named ranges” option, double-check the sheet name. Sheet names with spaces need quotes in formulas (e.g., 'My Sheet'!A1).
  • Removing the link but losing the text: The “Remove link” option keeps the text. If you want to delete the text too, select the cell and press Delete.
  • Using the HYPERLINK function incorrectly: The first argument must be the URL or a reference to a cell containing a URL. The second argument is optional; if omitted, the URL itself is displayed.

Tips

  • Use named ranges for easier linking to specific areas of your sheet. Go to Data > Named ranges to define one, then link to it directly.
  • Link to email addresses using mailto: in the URL field, e.g., mailto:someone@example.com.
  • Apply links to multiple cells at once: Select several cells, then insert a link. All selected cells will get the same link.
  • Use the HYPERLINK function with cell references: If you have a list of URLs in column A, you can create links in column B with =HYPERLINK(A1, "Visit") and drag down.

Troubleshooting

  • Clicking the link does nothing: Make sure the cell is not in edit mode. If you’re editing the cell, press Enter to exit. Also check that the URL is complete and starts with http:// or https://.
  • The link opens the wrong page: Double-check the URL for typos. If you used a sheet reference, verify the sheet name and cell reference are correct.
  • Link is not blue/underlined: This usually means the link wasn’t applied. Try re-inserting it via Insert > Link.
  • Can’t remove the link: If you used the HYPERLINK function, right-click and choose “Remove link” won’t work. You must delete the formula from the cell.
  • Link works in the browser but not in the mobile app: Some features may be limited in the mobile app. Try opening the sheet in a desktop browser for full functionality.

Frequently Asked Questions

Can I hyperlink to a specific cell in another sheet?

Yes. Use the “Sheets and named ranges” option and select a range, or type the reference like 'Sheet2'!B5 in the link dialog.

How do I make a hyperlink open in a new tab?

Google Sheets doesn’t have a built-in setting for this. The link will open in the same tab by default. You can use the HYPERLINK function, but it also opens in the same tab.

Can I change the display text of a hyperlink without changing the URL?

Yes. Click the cell, then press Ctrl/Cmd+K. In the dialog, edit the “Text” field, then click Apply.

Why is my HYPERLINK formula showing an error?

Common causes: the URL is not in quotes, the formula has extra spaces, or the sheet reference is invalid. Ensure the formula looks like =HYPERLINK("https://example.com","text").

Can I remove all hyperlinks from a sheet at once?

There’s no one-click “remove all” button. Select all cells (Ctrl+A), then right-click and choose “Remove link”. This removes links from all selected cells.

Does the HYPERLINK function work with relative references?

Yes. If you use a cell reference like =HYPERLINK(A1), it will use the URL in A1. When you copy the formula down, the reference changes relative to the row.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →