Hello everyone. We’ll discover how to remove hyperlinks in Google Sheets in this article. We frequently use original links or links that have been copied from other sources to use the browser to navigate the website. We can make hyperlinks in Google Sheets by adding a link to a certain text section or cell. However, there are situations when links can be annoying. For example, the blue color, blue underlining, and special formatting make a link look different from regular text. In other cases, we may copy text that contains a link and later decide we want to keep it as value text instead of a link, so those links must be removed. So, the purpose of this article is to explain how to remove hyperlinks in Google Sheets.
Why do we need to remove Hyperlinks in Google Sheets
Data cleaning: Because of information that has been copied or imported, your dataset may contain hyperlinks. To keep the dataset consistent and clean, it is important to clean up hyperlinks. This way, the information is concentrated on the actual content rather than pointless links.
Formatting Uniformity: Hyperlinks may sometimes change a cell’s formatting, making it different from the rest of your data. Eliminating hyperlinks contributes to a consistent look throughout your spreadsheet.
Ease of Analysis: Hyperlinks may make data analysis more difficult when working with large datasets. Eliminating them can make sorting, filtering, and computations easier, enabling a more efficient examination of the non-hyperlinked material.
Printing or Presentations: Removing hyperlinks from your spreadsheet might improve its readability and visual appeal if you intend to print it or use it in a presentation. When you wish to offer information without including links that are irrelevant or distracting, this is especially crucial.
You may also like>>> How To Remove Currency Symbol In Google Sheets [Multiple Methods]
How to Remove Hyperlinks in Google Sheets
There are numerous ways to remove hyperlinks in Google Sheets. To fully understand the methodologies, let’s begin by looking at those methods and using some dummy data.
I’m copying some connected data from the internet, and once I demonstrate how links work, we’ll look at some simple ways to remove hyperlinks.
Remove Hyperlinks in Google Sheets – Using the Link Icon below Link
This section explains how to remove hyperlinks in Google Sheets by utilizing the link icon that appears beneath a link when the cursor is over it. It is not appropriate to use this extremely simple way to delete hyperlinks in bulk if you have mass data because it can only remove one hyperlink at a time and requires you to repeat the process for each link. However, eliminating a single link may be the quickest method.
Below is a basic data set. I copied this list for my use, however, when I pasted it into Google Sheets, the copies turned into links right away. I’m becoming annoyed with the links, so I have to remove them now.
Step 1>
Demo Data
Step 2>
When you choose a cell with a hyperlink, a dialog box with the link’s data and several icons in the upper right corner will display.
Step 3>
Select the icon shown on the right (remove link).
Step 4>
Your link has been removed leaving the text as is (you can see that the underline has been removed to indicate that there isn’t a link, and you can no longer mouseover or click on that cell to view a dialog box).
This is the fastest way to remove a hyperlink, but what if I want to remove every hyperlink with a single click? No, this procedure simply removes the hyperlink for the final item in the selection; if I choose all and then do the same, none of the hyperlinks are removed at once.
Step 5>
Now let’s attempt to remove every hyperlink by choosing every entry in the list.
Step 6>
As you can see, just the final hyperlink has been removed; the others remain.
We’ll look at another easy method in the following section.
Remove Hyperlinks in Google Sheets – By Using Right-click and Unlink
This section will teach you how to use the right-click and unlink method in Google Sheets to delete hyperlinks. This technique is likewise quite simple and can remove every hyperlink with a single click. We’ll try to remove them all at once since I have the same data set.
Step 1>
Select every cell from which you wish to remove hyperlinks.
Step 2>
To view options, right-click on any cell.
Step 3>
To “view more cell actions”, go there.
Step 4>
Click on Remove link
All of the links in the cells you have chosen are immediately removed, leaving the content intact.
If you want to remove hyperlinks from several cells and ranges, this is the quickest way to do so.
Let’s look at our other methods for removing hyperlinks in the sections below.
Remove Hyperlinks in Google Sheets – By Using Copy & Paste Special
This section explains the most popular way used by seasoned Google Sheets users to remove hyperlinks: a straightforward copy-and-paste trick. This method can also be used to remove formulas. The straightforward process is to copy the material and paste it as values; the links and formula will be automatically removed, leaving simply the values, which is what we want.
Thus, I am demonstrating to you how to remove hyperlinks using this method utilizing the same data set.
Step 1>
Pick all the information from which you want to remove hyperlinks.
Step 2>
You can either right-click and select the copy button, or you can use the shortcut CTRL+C to copy the data.
Note: You can now copy them to the same location to obtain a copy for values alone, or you can copy them to the same location to replace the links with values.
Step 3>
Place your cursor where you wish to paste, then right-click.
Step 4>
Navigate to Paste Special> Values only (the short key is Ctrl + Shift + V).
Step 5>
Links have been removed, and your links are pasted as values.
You may wonder if any changes you make to your original links will show up in the copy of the values when you duplicate your links as values. No, since the paste method is not dynamic, they won’t reflect.
Don’t worry, however; we have another way to remove hyperlinks that preserves any changes made to your original data as you work. Yes, you can retrieve the links as values, and any changes made to the original links will automatically be reflected in your data.
In the part below, let’s explore this method.
Remove Hyperlinks in Google Sheets – By Using a Custom & formula
This section explains how to use a custom & formula to remove hyperlinks from Google Sheets. This is the only way that can provide you with real-time updates and changes whenever there is a change made to the original connection, making it the greatest option for real-time changes. Let’s see the process.
Using the same dataset, I will apply this method in the next column to obtain the link values for a new column.
Step 1>
Initiate the formula in the cell where the connections are to be obtained as values.
Step 2>
Although the formula is brief and simple to grasp, it can be difficult to understand.
=””$cell_reference
Step 3>
The cell where your link is written is known as the cell reference.
Step 4>
When you hit the Enter key, the value of the link will appear.
Step 5>
If you have additional links, you can fill the remaining space in the column by double-clicking the fill handle or by dragging the formula into the cells below.
Given that this method is dynamic, let’s modify the original URL to test it out.
Step 6>
modifying the URL a little bit
Step 7>
The modification is automatically reflected here, as you can see.
Here’s how this method operates. Hopefully, you’ve grasped and learned all of the methods mentioned above, and you can now use any of them to remove hyperlinks.
I hope this information is useful to you.
You may also like>>> How To Make An Inventory List On Google Sheets [Complete Guide]
Important Information
The first method requires that you first select the cell and then click on the icon to remove the link from the icon in the link dialogue box.
The remove link option can also be found on the first window in the second strategy, which involves using the right-click method to remove all hyperlinks simultaneously, rather than on the “view more cell actions” panel.
The third method paste as values can be used to replace links with values in the same location or to paste in a new location.
The fourth method, the custom formula approach, provides us with dynamic behavior that enables us to view real-time updates and changes made to the original linkages. Using the third option, which involves copying and pasting all the values produced by the formula, you can halt them.
Frequently Asked Questions
Will the wording in the cells change if hyperlinks are removed?
No, removing hyperlinks in Google Sheets won’t change the text content; it will just remove the hyperlink formatting.
Can I remove the hyperlink again if I need to?
Yes, you’re able to undo the changes right away after removing hyperlinks by using the “Undo” option (Ctrl+Z or Command+Z).
Will the underlying data or algorithms be impacted if hyperlinks are removed?
No, the formulas, underlying data, or any other cell property remain unaffected by the removal of hyperlinks from Google Sheets.
Does Google Sheets include keyboard shortcuts for removing hyperlinks?
Yes, you can rapidly remove hyperlinks from selected cells by using the keyboard shortcut Ctrl + ~ (backtick).
You may also like>>> How To Convert Microsoft Word To Google Doc (3 Simple Methods)
Conclusion
We discovered four easy ways to remove hyperlinks in Google Sheets, which will simplify the way your data is presented. With these tips at your disposal, you may effectively handle hyperlinks in your sheets to give them a more polished appearance. For more keep learning with OfficeChaser.