As we all know, MS Excel is a powerful spreadsheet program for data organization that often uses hyperlinks to navigate between worksheets or external resources seamlessly. However, there are instances when Excel converts the entire URL and the email address into clickable hyperlinks, which is a bit annoying. In this article, we will delve into the quick methods to remove hyperlink in Excel, from manual procedures to advanced functions like VBA.
So, let’s begin…
To fix Excel file & recover its worksheet data, we recommend this tool:
This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:
- Try Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.
- Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.
- Preview the repaired files and click Save File to save the files at desired location.
Understanding Hyperlinks in MS Excel
In MS Excel, Hyperlinks serve as shortcuts, allowing users to redirect to different locations or external websites. While they improve navigation, there are instances when removing hyperlinks becomes a necessity, whether for aesthetic reasons, data cleansing, or preventing accidental clicks.
Can I Remove All Hyperlinks at Once in Excel?
The answer to this question is “Yes.” You can remove all hyperlinks at once in Excel. Now, you must be thinking how, right?
To do so, you have to select the range of cells in the sheet that contain the hyperlinks by pressing Ctrl + A keys together. After this, right-click anywhere within the selected cells & choose the “Remove Hyperlinks” option from a Context menu.
Why Is It Necessary to Remove Hyperlinks in A Document?
In Excel, hyperlinks are useful, but sometimes they become very irritating as they may cause clutter and hinder keeping the data organized. Removing the links in an Excel document enhances the overall appearance of a spreadsheet, diminishes clutter, and guarantees that users interact with data intentionally.
How to Remove All Hyperlinks in Excel in a Few Steps?
Here find out the easy ways to remove Hyperlinks.
- You can select the full column with hyperlinks by clicking the CTRL + A keys.
- “Remove hyperlinks” can be chosen from the context menu by right-clicking on any selected cell.
- And all the hyperlinks are removed.
Also Read: How to Use ChatGPT to Write Excel Formulas
How to Remove a Link in Excel from Editing Group of the Home Tab?
If you’re using Excel 2010 or a later version, you can remove multiple hyperlinks in one go. To do this, you have to follow these steps:
- Select the range of cells in the sheet that contain the hyperlinks by pressing Ctrl + A keys together.
- Then, go to the “Home” tab >> find the Editing group >> click on a Clear option.
- Under the drop-down list, choose the “Remove Hyperlinks.”
How to Remove Hyperlink in Excel using VBA?
Suppose you are still utilizing an earlier version of Excel. Or perhaps you have used the right-click context menu too frequently because your workbook contains many hyperlinks.
In this case, you can use VBA macro code to remove multiple hyperlinks in Microsoft Excel.
- To open your VBA editor, press Alt+F11.
- Double-click on ThisWorkbook in the Project Window that is now visible in the VBA editor’s left-hand corner.
- Next, copy and paste the listed VBA code into the Module window:
‘ VBA Code to Remove all Hyperlinks in Excel
Sub RemoveAllHyperlinks()
Dim Ws As Worksheet
On Error Resume Next
For Each Ws In ActiveWorkbook.Worksheets
Ws.Hyperlinks.Delete
Next Ws
End Sub
- To run the VBA code module, press F5.
- This will instantly erase all of the hyperlinks from your workbook. They are no longer a concern for you. But bear in mind that this action cannot be undone. Ctrl+Z cannot be used to reverse the removal of hyperlinks.
This VBA code can be saved as a simple, click-and-forget button on the QAT (Quick Access toolbar). This is an easy trick to remove all the hyperlinks from the Excel spreadsheet in just a few clicks.
- Close the VBA editor window after adding the VBA code module.
- Select More Commands by clicking the Customize Quick Access Toolbar
- Choose Macros from the drop-down list under Choose commands from the drop-down list in the Excel Options box.
- Select the VBA code module that we just added by scrolling down and doing so.
- Click OK after selecting Add.
- Just that. The Quick Access toolbar will receive a quick-access button for running this VBA code.
These are the 2 detailed ways to remove clickable hyperlinks in Excel.
How to Remove Multiple Hyperlinks Excel Using Paste Special?
Only one built-in function in Excel 2000-2007 allows you to erase several hyperlinks simultaneously. Here is a quick tip that will help you get around this restriction. It works in Excel 2019, 2016, and 2013 as well.
- Choose a blank cell somewhere outside of your table.
- To this cell, enter 1, and Ctrl + C will copy this cell.
- Choose your columns using the hyperlinks: To select the entire first column, click any cell containing data and then press Ctrl+Space.
- If you wish to pick multiple columns at once, choose the first column first, then while holding down the Ctrl key, click any cell in the second column, and then hit the Space key to select every cell in the second column without affecting the selection in the first column.
- Right-click any chosen cells to bring up the context menu, then choose “Paste Special“:
- Select the “Multiply” radio button in the “Operation” section of the “Paste Special” dialogue box:
- Hit “OK.” All links have been disabled.
Also Read: Open Excel in Safe Mode: The Lifesaver for Excel Spreadsheets
How to Turn off Excel’s Automatic Hyperlink Creation?
When it is not convenient to have MS Office automatically generate hyperlinks in your Excel document as you type, you can easily disable it by following the below steps:
- Select Excel Options from the Office button in Excel 2007.
- Navigate to the File Tab -> Options in Excel 2010 – 2019.
- Select the “Proofing” tab in the left column of the “Excel Options” dialogue box, then click the “AutoCorrect Options” button:
- Select the “AutoFormat As You Type” tab in the “AutoCorrect Options” dialogue box, then uncheck the “Internet and network routes with hyperlinks” checkbox.
- To end both dialogues and return to your Excel spreadsheet, click OK.
- Now, you can enter any URL or email address into any cell, and Excel will maintain the plain text format:-)
- Use Ctrl+K to bring up the “Insert Hyperlink” dialogue box whenever you need to build a hyperlink.
Related FAQs:
What Is the Shortcut to Open a Hyperlink in Excel?
Ctrl + K is the shortcut to open the hyperlink in Excel.
Can I Remove Hyperlinks Selectively Using Excel Functions?
Yes, there are two Excel functions that can help you to remove hyperlinks selectively, one is HYPERLINK and another is SUBSTITUTE.
Why Is Excel Typing in Hyperlink?
By default, MS Excel converts text to a hyperlink if it determines your data in the cell is in a URL or email address format.
Can VBA Code Be Used by Excel Beginners to Disable Hyperlinks in Excel 365?
No, it is not recommended to go for VBA method if the user is beginner to turn off hyperlinks in Excel.
How Do I Remove a Hyperlink from An Email in Excel?
To remove hyperlink from email in Excel, follow these steps:
- Select the column of ‘Email ID’.
- Right-click & select ‘Remove Hyperlinks’ option.
Also Read: How to Remove Scientific Notation in Excel?
Say Good Bye
Removing hyperlinks in Excel is a valuable task that makes your spreadsheet more organized & visually appealing. By following the best practices outlined in this blog, you will streamline your Excel usage & boost your overall experience.
You can now also follow us on our Facebook, and Twitter pages and share your queries related to Excel errors, corruption, data recovery, and others; our experts will get back to you.
Priyanka Sahu
Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.