How to Add or Remove Hyperlinks in Google Sheets

How to Add or Remove Hyperlinks in Google Sheets.Adding a hyperlink is one of the best ways to quickly access anything in a spreadsheet. You can link to a cell, a range of cells, another sheet, and even a web page in Google Sheets.We’ll show you how to add hyperlinks to your worksheet and remove links in Google Sheets that you no longer need.

Link to a Cell or Cell Range

If you have a large Google spreadsheet full of data and want to frequently visit a single cell or range of cells, you can easily create a link to it.

Select the cell where you want to place the hyperlink. If the cell contains text, that text will be linked. You can also add the text you want when creating the link.
To insert a link, do one of the following:
Right-click and select Insert Link.
Click the Insert Link button on the toolbar.
Select Insert > Link from the menu.

When the “Insert Link” window appears, you will see the contents of the cell you want to link in the Text box at the top. If the cell is empty, you can enter text in this field to connect to the link.

Go to the bottom of the popup and select Tables and Named Ranges.

Go to the bottom of the next screen and select Select a cell range to link.

Either enter a cell reference or range of cells starting with the sheet name in the next dialog box, or use the cursor to select a cell or range to automatically fill in the field.
Confirm the cell or range and click OK.

You will then see the linked text inside the cell. Select a cell and use the link in the preview to navigate to the cell or range of cells.

Link to a Named Cell Range

If you are using named ranges in your worksheet, this gives you another linking option.

Follow steps 1 through 3 above to select a cell, open the Insert Link window, and edit or add link text as needed.
Go to the bottom of the popup and select Sheets and Named Ranges.
If necessary, scroll down the next screen to the Named Ranges section and select a range.

When a named range is referenced in a cell, use Enter or Return to save it.

If you don’t see a named range in the list, it’s likely that it hasn’t been named yet. To do this, select a range of cells, right-click and select View More Cell Actions > Define Named Range< /span>. When the Named Ranges sidebar appears on the right, enter a name for the range and select Done. You can then follow the previous steps to link this named range.

Link to Another Sheet

If you want to link to another spreadsheet in your Google Sheets book, this is a handy way to jump straight to it when needed.

Follow steps 1 to 3 earlier.
Go to the bottom of the popup and select Sheets and Named Ranges.
Go to the Sheets section and select a sheet name.

When a sheet reference appears in a cell, use Enter or Return to save it.

Link to a Web Page

If you want to link to a website or a specific web page, you have several different ways to do so in Google Sheets.

Use the Paste action

Probably the easiest way to paste a web link to a sheet is to copy and paste the URL.

Go to the address bar of your web browser and copy the link. You can do this by selecting the URL, right clicking and selecting Copy.

Go back to Google Sheets and select the cell you want to add the link to, right click and select Insert.

You will see the hyperlink in the cell. If you want to change the name rather than display the URL, select the link preview cell and click the Change Link button (pencil icon).

Enter a name in the Text field and select Apply< /span >.

Use the embed link function

Another way to link to a site or page is to use the “Insert Link” feature described earlier.

Select the cell you want to add a link to and do one of the following:
Right-click and select Insert link.
Click the Insert Link button on the toolbar.
Select Insert > Link from the menu.
Find, type or paste a link in Find or paste a link.
If necessary, add or change the name in the Text field and select Apply >.

Use the HYPERLINK function

If you enjoy using functions and formulas in Google Sheets, you can also use the HYPERLINK feature to insert your link.The formula syntax is “HYPERLINK(url, label)” where only the URL is required. You can use the label argument to make the text refer to a URL. Make sure both arguments are enclosed in quotation marks.To insert a link to Online Tech Tips, you must use this formula:=HYPERLINK(“https://www.online-tech-tips.com”) To insert a link to Online Tech Tips labeled OTT, you must use this formula:=HYPERLINK(“https://www.online-tech-tips.com”,”OTT”)

Remove Hyperlinks in Google Sheets

If you later decide to remove the hyperlinks you’ve added or import data or sheet from another location and you don’t need the included links, you can remove them.

Remove single link on sheet

Perhaps you have a specific hyperlink that you would like to remove. You can do it in the blink of an eye. To remove an individual link, do one of the following:Select the cell containing the link and click the Remove Link button (broken link icon) in the preview. Right-click a cell with a link and select View Other Cell Actions > Remove Link . The hyperlink is removed, but the link text remains in the cell.

Remove all links on the sheet

Perhaps you have many links in your sheet. Instead of removing them one by one, you can take care of them all in one fell swoop.

Select the entire sheet using the Select All button (the square in the upper left corner). You can also use the keyboard shortcut Ctrl + A on Windows or Command + A on Mac. .

Right click anywhere on the sheet, select View More Cell Actions and select Remove Link.

You should see all the hyperlinks on your sheet disappear, but any text you used for links remains.

If you need a quick way to jump to another cell, sheet, or web page, you can add hyperlinks to Google Sheets in a variety of ways.For more helpful productivity tips, see How to use find and replace in Google Sheets.