In Excel if we input an URL, it automatically converts the URL to hyperlinks which is not helpful all the time. Mistakenly selecting the cell containing hyperlink can open a website. So we may want to remove the hyperlinks but keep the text on the cell or multiple cells. In this article, we will show you some basic ways to remove all hyperlinks in Excel without removing the text.
In this section, we will show you 5 very easy and useful methods to remove all the hyperlinks in Excel. To show the method we are using a dataset consisting of several hyperlinks in it.
Method 1: Using Built-in Option from Context Menu
For removing any hyperlink Excel has a built-in option which is very simple to use. In this method, we will show you how to use the option to remove all hyperlinks in Excel while keeping the text.
Step 1: Select the cell or range of cells those contain the hyperlinks.
Step 2: Right click on the selected cells and in the bottom there will be an option Remove Hyperlink. Clicking on the option.
All the hyperlinks will be converted to plain text.
Method 2: Using Paste Special Command
In Excel versions before 2007, the built-in option shown above is not present. No worry even then we can remove all hyperlinks in Excel very easily using Paste Special. In this method, we will show that.
Step 1: At first we select an empty cell and put numerical value 1 in it and copy the cell.
Step 2: Then we select the range of cells that contain the hyperlinks and right click on that and choose Paste Special from the option.
Step 3: Paste Special window will open and we select Multiply from the operation section. Then we press OK.
And the hyperlinks will be removed.
Method 3: Using Paste Text Only Option
Sometimes we copy an URL and want to paste the text only on an empty cell. In this method, we will show how to do that simply to remove hyperlinks in Excel.
Step 1: Firstly we copy the URL of a site. In our case, we copied the URL of the Amazon site.
Step 2: Then we select the empty cell where we want to keep the text. Right-click on that and we select Paste Only Text from the Paste option. Only the text will be copied to the cell.
Read More: How to Remove Excel Links from Word Document
In spite of removing the hyperlinks, we may want to stop Excel from making a hyperlink. In this method, we will show how to do that.
Step 1: At first we go to File>Options in Excel. The Excel Options will pop up. Then we select Proofing>Autocorrect from the menu.
Step 2: An Autocorrect window will pop up. We need to select AutoFormat As You Type.
Step 3: Then we deselect Internet and network paths with hyperlinks. We click OK. After this, no hyperlinks will be connected to any cell in Excel.
Macro in Excel is a recorded order of options. We can use a macro to remove the hyperlinks from the specific sheet of workbook. We can set up a macro using Visual Basics for Application (VBA) code very efficiently.
Step 1: At first we Press the ALT+F11 keys to open the VB editor window.
Step 2: Select ThisWorkbook or the desired worksheet from the VBA project panel.
Step 3: In the VBA code window we write the following code
Sub mhRemoveAllHyperlink() ActiveSheet.Hyperlinks.Delete End Sub
Step 4: We can run the sub by selecting Run at the top. Then we move the window out of the way. All the hyperlinks in the worksheet will be removed.
Step 5: There’s another way to run the sub. We close the VBA window and come back to the active worksheet and press ALT+F8 which will open the Macro window, we select ThisWorkbook.RemoveAllHyperlinks from the list and press Run.
Hurrah! all the hyperlinks from our worksheet will be removed.
Keeping hyperlinks in the sheet causes hazards sometimes. so removing the hyperlinks but keeping the text may be required. In this article, we have shown 5 simple ways to remove all hyperlinks in Excel. You can use any one of them as you like. Hope this article will help you. If you face any problem doing it or if you have any recommendations please let us know by comments.