How To Use AI To Remove Hyperlinks in Excel
Feb 03, 2025
Did you know you can use AI to remove hyperlinks in Excel?
Since Excel doesn't have a one-click way to bulk remove hyperlinks, cleaning up messy spreadsheets filled with unwanted links can be difficult. Fortunately, you can save valuable time with the help of artificial intelligence. Whether you're dealing with a few links or hundreds, AI offers an efficient solution.
This post explores how artificial intelligence can make hyperlink cleanup in Excel quick and effortless.
Steps to Remove Hyperlinks in Excel Using ChatGPT
You can delete all the hyperlinks in your Excel sheet at a go with a VBA code. Using VBA (Visual Basic for Applications) is also your best bet to remove hyperlinks but preserve your cell formatting.
However, we understand writing a VBA code requires a certain level of technical proficiency, which is where AI tools come in. See how to get a VBA code that removes Excel hyperlinks from ChatGPT below:
-
Ask ChatGPT for a specific VBA code: Use a prompt like, "Can you provide a VBA code that removes all hyperlinks from an Excel sheet?" ChatGPT can generate a simple and effective code for this task.
-
Copy the VBA code: Once ChatGPT provides the code, copy it to your clipboard.
-
Open the VBA editor in Excel: Press Alt + F11 to open the VBA editor window. Go to Insert > Module, then paste the code into the newly inserted module window.
-
Run the VBA code: Press F5 to execute the code or close the VBA editor, return to your sheet, and run the macro from the Developer tab.
The below code is an example VBA code you could request:
Sub RemoveAllHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub
Removing a Single Hyperlink Manually
You can manually remove a hyperlink from the right-click context menu. This is the quickest and easiest method.
-
Locate the cell containing the hyperlink.
-
Right-click on the cell.
-
Locate and select Remove Hyperlink at the bottom of the list to remove the hyperlink.
Note: The hyperlinked cell’s formatting, such as font color or underlining, will remain.
Removing Multiple Hyperlinks in Excel Manually
If you have multiple hyperlinks to clear, doing it manually for each cell can be tedious. Fortunately, Excel has a feature that simplifies the process. Here's how to remove multiple hyperlinks via the Ribbon:
-
Select all the cells containing hyperlinks.
-
Go to the Home tab in the ribbon.
-
In the Editing group, click on Clear.
-
From the drop down menu, select Remove Hyperlinks to remove hyperlinks in the selected cells.
Removing All Hyperlinks in an Excel Worksheet Manually
You can delete all the hyperlinks in your Excel sheet by selecting and removing them. Follow the below steps to clear hyperlinks in sheet:
-
Press Ctrl + A to select the entire worksheet.
-
Right-click anywhere within the selection.
-
Choose Remove Hyperlinks from the context menu.
How to Disable Automatic Hyperlink Creation
Ever noticed that Excel automatically converts URLs or email addresses into hyperlinks? If this feature bothers you, you can disable it permanently. When you adjust your settings as stated below, Excel will no longer add hyperlinks automatically when you type URLs or email addresses.
-
Click on the File tab and select Options.
-
In the Excel Options dialog box, click Proofing.
-
Select AutoCorrect Options.
-
Navigate to the AutoFormat As You Type tab.
-
Uncheck the box labeled Internet and network paths with hyperlinks.
-
Click OK to save your changes.
Final Thoughts on "How To Remove Hyperlinks"
Removing hyperlinks in Excel doesn’t have to be a daunting task, especially with tools like VBA and AI at your disposal. Whether you’re tackling a single hyperlink or clearing hundreds, these methods can save you time and effort. Follow the steps outlined in this post to have clean, professional-looking spreadsheets!
For more easy-to-follow Excel guides and the latest Excel Templates, visit Simple Sheets and the related articles section of this blog post.
Subscribe to Simple Sheets on YouTube for the most straightforward Excel video tutorials!
FAQ on "How To Remove Hyperlinks"
1. Can I remove hyperlinks in Excel without using VBA?
Yes, you can manually remove hyperlinks by selecting the cells, right-clicking, and choosing Remove Hyperlinks from the menu. For multiple cells, select the range, right-click, and follow the same steps.
2. What’s the easiest way to remove all hyperlinks in Excel?
The easiest way is to use a simple VBA code like ActiveSheet.Hyperlinks.Delete to remove all hyperlinks at once. If you’re not comfortable writing code, tools like ChatGPT can help you generate the code.
3. How can I stop Excel from automatically creating hyperlinks?
Go to File > Options > Proofing > AutoCorrect Options. Under the AutoFormat As You Type tab, uncheck Internet and network paths with hyperlinks and click OK. This will stop Excel from turning URLs into hyperlinks automatically.
Related Articles
Want to Make Excel Work for You?ย Try out 5 Amazing Excel Templates & 5 Unique Lessons
We hate SPAM. We will never sell your information, for any reason.
