How to Remove Hyperlinks in Google Sheets (3 Easy Ways)

Watch Video – Remove Hyperlinks in Google Sheets

Hyperlinks are quite useful in Google Sheets when you’re working with web page data.

Or when you have links to files and folders where you can simply click on the link and go to that location.

But sometimes, it may also be annoying.

Mostly in my work, I have to copy and paste data from the web into a Google spreadsheet, and then work with this data.

If the original data has hyperlinks, these hyperlinks would also come as a part of the formatting in Google Sheets.

And since I do not want these hyperlinks, the first thing I have to do is remove these hyperlinks from the cells in Google Sheets.

In this tutorial, I will show you a couple of methods to quickly remove hyperlinks in Google Sheets.

How to Remove Hyperlinks in Google Sheet

1. Select the range with the hyperlinks
2. Right click on any of the cells
3. Go to View more cell actions > Remove Link

Learn it All at Once

This guide is a fairly straightforward one. But, do you often find yourself coming to sites like ours to figure how to do certain tasks in Google Sheets? You could save a lot of time in the long run by simply completing a comprehensive Google Sheets course to become a power user.

Removing Hyperlinks From Cells

Below I have a data set of the top 10 movies (so far) according to IMDb.

Since I copy-pasted this data from this page, you can see that there are hyperlinks on each of the movie names.

Below are the steps to remove the hyperlinks from these cells:

1. Select all the cells from which you want to remove the hyperlink
2. Right-click anywhere on the selection
3. Go to View more cell actions
4. Click the ‘Remove link‘ option

The above steps would remove the hyperlinks from all the selected cells.

Note that this is only going to remove the hyperlinks, while all the other formatting in the cells that you may have gotten because of copying it from a web page would still remain.

if you want to remove the link from a single cell, hover the cursor over the cell, and you’ll see some options show up. Click on the ‘Remove link’ icon to delete the hyperlink.

The methods shown in this tutorial would also work if you have created the link using the HYPERLINK function in Google Sheets. You can also select the entire column to have Google Sheets remove hyperlinks from column.

Removing All Hyperlinks at Once in Google Sheets

If you want to remove every hyperlink in your sheet all at once you can do this:

1. Select the entire sheet using CTRL + A or clicking the top left corner box under the formula bar.
2. Right click anywhere in the sheet.
3. Go to View more cell actions > Remove Link

This should remove all the links in your spreadsheet simultaneously.

Removing Hyperlinks Using Paste Special

In most cases, when you’re copying the data from a web page, you just need the text and not the formatting and the links that come with it.

While the above method works well, it does not get rid of the cell formatting (such as font size, cell colors, etc.).

The fastest way to do this would be to simply copy the content of the cell and paste it as a value somewhere else in the worksheet.

Suppose you have a dataset as shown below and you want the text without the hyperlinks:

Below are the steps to quickly copy the text and paste it as values:

1. Select the cells that have the hyperlinks
2. Copy these cells (you can use the keyboard shortcut Control + C in Windows and Command + C in Mac), or right-click on the selection and then click on copy
3. Right-click on the cell where you want to copy this data (in this example, I am going to use cell B2)
   

   

4. Hover the cursor over the ‘Paste special’ option
   

   

5. Click on ‘Paste values only’

The above steps would copy the data and paste only the values while getting rid of all the formatting and the hyperlinks.

Now you can copy this data and paste it over the hyperlink data, or delete the original data and use this data going forward.

Removing Hyperlinks Using a Formula

Althoug there’s no specific Google Sheets remove hyperlink formula, another quick way to remove hyperlinks from a range of cells is to use a simple formula that would give you the same text in those cells (in separate columns) but remove all the formatting and the hyperlinks.

The benefit of this method is that your resulting data would automatically update if you make any changes to the original data.

Suppose you have a data set as shown below, and you want to get the text from the hyperlinks in column A.

To do this, use the below formula in column B

=””&A2

Copy this formula for the entire column to get the text from all the hyperlinks in the adjacent cell.

This formula works as we are concatenating the text in cells in column A, with a blank character. doing this automatically converts the text in the referred cell (which is cell A2 in this case) to regular text.

If you don’t add the blank character and simply use =A2, it will bring over the hyperlink as well.

How to Disable Google Sheets Link Preview

Usually, when you click or hover on a link in Google Sheets, a previews of the website will appear. It can get pretty annoying every time you accidentally hover over a link, and the link preview pops up.

Luckily, they recently added a Google Sheets disable link preview feature where you can disable this option. However, the only way to turn this on is by using Google docs. Here’s how to disable Google Sheets link preview:

1. Go to Google Docs
2. Go to Tools > Preferences

3. Under the General tab, uncheck “Show link details.”

4. Click Ok.

Now if you go back to Google Sheets and try hovering the cursor over a link, the link preview won’t appear. However, a smaller pop-up of the link will still appear, and there’s no way to remove this completely.

How to Remove Hyperlinks in Google Sheets Mobile App

Removing hyperlinks on the mobile app is not difficult to do. It’s pretty similar to the desktop method, with just a few tweaks. To remove hyperlinks on mobile:

1. Tap the hyperlink
2. Click the three dots for more options.

3. Tap Remove Link.

Using this method, your text will instantly be unlinked. If you want to remove multiple links you may have to do it one by one because you can’t remove links at once on the Google Sheets mobile app.

You can, however, use the Paste special method to remove links in the mobile app instead of removing them one by one.

Final Thoughts

So these are some of the methods that you can use to quickly remove hyperlinks from cells in Google Sheets.

I hope you found this tutorial useful. You can also have a look at our guide for table of contents in Google Sheets.

Other Google Sheets tutorials you may also like:

• How to Clear Formatting in Google Sheets
• How To Remove Duplicates In Google Sheets
• How to Remove Dollar Sign ($ or USD) in Google Sheets?
• Remove Extra Spaces in Google Sheets (Leading, Trailing, Double)
• How to Hyperlink in Google Docs in 2 Seconds