This guide will explain how to remove all hyperlinks in Excel.
Removing all hyperlinks in an Excel sheet can help streamline the look of a document and make it easier to read. You may also want to prevent users from clicking on a hyperlink accidentally.
We’ll tackle two methods to remove all hyperlinks in a spreadsheet.
The simplest option to use is the Remove Hyperlinks command. The Remove Hyperlinks option will strip the link from the text while leaving the text itself intact.
The Paste Special command is a versatile tool that can be used for various tasks in Excel. We can use the Paste Special command to remove hyperlinks from a document by using it only to paste the values of our selection.
Let’s take a look at a simple example where we can benefit from removing hyperlinks.
Suppose you have an Excel directory that you want to print out. Sometimes, hyperlinks of emails, phone numbers, and URLs can be difficult to read when they are printed on a document. By removing the hyperlinks, you can make the document easier to read.
Now that we have a good idea of when to remove all hyperlinks, let’s see how this works on an actual sample spreadsheet.
A Real Example of Removing All Hyperlinks in Excel
The following section provides several examples of how to remove all hyperlinks in Excel. We will also go into detail about the formulas and tools used in these examples.
First, let’s take a look at a sample spreadsheet with multiple hyperlinks. In the example below shows a directory of registered members for a specific organization.
The directory has two columns that include hyperlink text. One issue the user may encounter when working with these sheets is that they may be difficult to select. This is because clicking on these cells will open the link in the user’s default browser.
There are also several cases where hyperlinks are not necessary at all. For example, we may not want to have a hyperlink for the member’s email.
We can use Excel’s Remove Hyperlinks option and the Paste Special command to convert hyperlink text into plain text.
Do you want to take a closer look at our examples? You can make your own copy of the spreadsheet above using the link attached below.
If you’re ready to try out removing all hyperlinks in Excel, head over to the next section to read our step-by-step breakdown on how to do it!
How to Remove All Hyperlinks in Excel
This section will guide you through every step needed to remove all hyperlinks in Excel.
We’ll explain a few different methods that you can use to convert hyperlinks into plain text. We will also show how to prevent Excel from formatting URLs into hyperlinks automatically.
Follow these steps to start removing all hyperlinks in your spreadsheet.
- Select the cell or cell range that includes the unnecessary hyperlinks. In this example, we’ll select the range D2:E31.
- Right-click on the selection and click on the Remove Hyperlinks option.
- Your cell or cell range should no longer have any text formatted as a hyperlink.
- Next, we’ll use the Paste Special method to remove all hyperlinks in a given range. Select the range that includes the hyperlinks. Type the keyboard shortcut Ctrl + C to copy the selection to your clipboard.
- Find another range to paste our results. Right-click on the starting cell of this range and hover over the Paste Special option. Click on the Paste Values icon, as seen below.
- You should now have a copy of your range without any included hyperlinks. You may now delete the original range from your spreadsheet.
Do you want to prevent Microsoft Excel from creating hyperlinks automatically in the first place? We’ll show you how to edit your Excel program’s settings to stop Excel from adding hyperlink formatting automatically to URLs and email addresses.
- First, head to the File tab and click on Options. In the Excel Options dialog box, click on the Proofing tab. Select the button labeled AutoCorrect Options.
- In the AutoCorrect dialog box, navigate to the AutoFormat As You Type tab. Check the option labeled ‘Internet and network paths with hyperlinks’. Click on OK to apply these new changes.
These are all the steps you need to remove all hyperlinks in Excel and prevent Excel from formatting links automatically.
This step-by-step guide should serve as a quick introduction to removing all hyperlinks in Microsoft Excel.
You should also understand how to access the Remove Hyperlinks option and the Paste Special command to convert hyperlinked text into plain text.
This function is just one example of the many Excel functions you can use in your spreadsheets. Our website offers hundreds of other functions and methods to help you get more out of Microsoft Excel.
With so many other Excel functions available, you can find one appropriate for your use case.
Don’t miss out on our team’s new spreadsheet tips, tricks, and best practices. Subscribe to our newsletter to stay updated on the latest guides from us!