How to☝️ Remove Hyperlinks in Google Sheets

To remove links in Google Sheets, double-click on the cell with a hyperlink and press the Remove link icon. 

In this article, we will go over the methods on how to remove links in Google Sheets in just a few seconds.

Below you will find a detailed guide that will describe the process thoroughly, whether you are using a desktop or mobile.

The Quickest and Easiest Way to Remove Hyperlinks

If you want to remove a link from a single cell, the following method works quite well:

Difficulty: Beginner

Time Estimate: 3 seconds

  1. Double-click on the cell with a hyperlink.
  2. Click on the Remove link icon.

The Quickest and Easiest Way to Remove Hyperlinks

Voila! It’s that simple.

Removed Hyperlink

Note: In the same way, you can erase an email link from a cell in Google Sheets. The following illustration shows how it’s done:

Removed Email Link

How to Use a Custom Formula to Remove Hyperlinks

See how to remove hyperlinks using a formula, which can be handy in certain situations:

Difficulty: Beginner

Time Estimate: 5 seconds

  1. Click on a blank cell.
  2. Go to the Formula bar and enter the formula =””&A1, where A1 is the cell with a link.

How to Use a Custom Formula to Remove Hyperlinks

  1. Press the Enter key on your keyboard. 

How to Use a Custom Formula to Remove links

Here it is! If you want to apply the formula to other cells, click the icon in the lower right corner of the cell and drag it downward to copy the formula for the rest of the list.

Dragging the Cell

Easy as ABC!

How to Remove All Hyperlinks at Once

Many Google Sheets users are looking for information on how to remove hyperlinks from multiple cells at once as opposed to removing a hyperlink one cell at a time. Below is a step-by-step guide on how to do this with little effort: 

Difficulty: Beginner

Time Estimate: 4 seconds

  1. Select the hyperlinks you need to unlink.
  2. Right-click on the selected cells.
  3. Choose the Paste special option.
  4. Select Values only

How to Remove All Hyperlinks at Once

The process is easy as pie! Check out the result below.

Removed Links in Google Sheets

How to Remove Hyperlinks in Google Sheets on Mobile Devices

When you are using Google Sheets on your mobile device, the following method must be followed in order to remove a link from your spreadsheet:

Difficulty: Beginner

Time Estimate: 5 seconds

  1. Select a blank cell.
  2. Navigate to the Formula bar and enter the formula =””&A1. Here A1 is the cell with a hyperlink.
  3. Click on the checkmark to apply the formula.

How to Remove Hyperlinks in Google Sheets on Mobile Devices

And there you go! The link has been removed from the text.

Removed link

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X