Microsoft Office suite offers a lot of productivity features to make our work easier when creating, editing and formatting documents. Hyperlinks in Excel are automatically created when you insert a URL or an email id.
While Excel’s hyperlinks are helpful when you want to open a specific page in your browser, to access a new file in the same spreadsheet or to link to a different spreadsheet in the same workbook, some users find this feature frustrating. If you have multiple hyperlinks, removing them manually could be exhausting.
Today’s article covers:
- How to find all the hyperlinks in Excel
- How to remove all hyperlinks in Excel
- How to turn off automatic hyperlinks in Excel
How to find all the hyperlinks in Excel
To quickly find all the hyperlinks in your spreadsheet or the entire workbook with a list of cells that have it, use the Find and Replace feature.
- Open your spreadsheet, and click Home.
- Go to Editing > Find & Select > Replace. (Alternatively, press CTRL + H).
- Within the Find and Replace dialogue box, click Replace > Options.
- Click the “Format” button, next to “Find what” text box to open a dropdown list.
- Select the “Choose Format From Cell” option.
- Select all the cells that have hyperlinks. This populates the “Preview” pane with the hyperlink format, next to the “Format” button.
- Click “Find All” to show a list of all the cells with hyperlinks.
- You can now select each link manually or use the CTRL key to select multiple cells.
How to remove all hyperlinks in Excel
Whether you’ve received a spreadsheet that has unnecessary links or you no longer want the links that you added, there are various ways to remove all the hyperlinks with ease.
Method 1: Delete all hyperlinks by choosing all the cells
- Select your entire worksheet by clicking the tilted triangle at the top left corner of your spreadsheet. (Or, simply press CTRL + A).
- Right-click anywhere in your worksheet, and select “Remove Hyperlinks.”
- This easy step clears all the hyperlinks from your spreadsheet.
Method 2: Remove hyperlinks using Paste Special
- Select all the cells that you want to unlink. Press and hold the CTRL Key when selecting multiple cells.
- Right-click within the spreadsheet, and select “Copy.”
- Now, select a blank cell and right-click on it.
- Click the “Paste Special” option to open the Paste Special dialogue box.
- Select the “Values” option, and click OK.
- This pastes the texts without the hyperlinks.
- Delete the original cells containing the hyperlinks.
Method 3: Delete hyperlinks using the Find and Replace feature
- Go to Home > Editing > Find & Replace > Find. Alternatively, press CTRL + F.
- This opens the Find and Replace dialogue box.
- Click the “Format” button, to open a dropdown list.
- Select “Choose Format From Cell.”
- Select the cell with the hyperlink. This action shows the “Preview” pane with the hyperlink format.
- Click “Find All” to list all the cells with hyperlinks in Excel.
- To select all the hyperlinks, press CTRL + A.
- To select specific hyperlinks, use the CTRL Key.
- Right-click on the highlighted cells, and click “Remove Hyperlinks.”
Method 4: How to remove hyperlinks with specific text
Suppose you have a dataset of companies which were accidentally linked more than once. Say, you want to remove the hyperlink with the text Company 2, here are the steps to follow:
- Use shortcut keys CTRL + F to open the Find and Replace dialogue box.
- Click the “Options” button.
- Type Company 2 in the “Find what” text box.
- Select “Choose Format From Cell” from the dropdown menu by clicking the “Format” button.
- Select the cell with Company 2. This shows the “Preview” pane with the hyperlink format.
- Now, click “Find All” to display all the hyperlinks associated with Company 2.
- If you want to erase specific cells with hyperlinks, hold the CTRL Key and click on the hyperlinks you intend to delete.
- To select all the hyperlinks, press CTRL + A.
- To remove the selected hyperlinks, right-click on one of the highlighted cells and select “Remove Hyperlinks.”
How to turn off automatic hyperlinks in Excel
If you find it inconvenient for Excel to automatically create hyperlinks, you can turn the hyperlink function off.
- Open File > Options > Proofing > AutoCorrect Options.
- In the AutoCorrect dialogue box, click the “AutoFormat As You Type” tab.
- Unmark the box next to “Internet and network paths with hyperlinks.”
- Click OK.
That’s it. Excel will no longer insert links automatically. This change will apply to all your workbooks.
The more you use your computer, the more junk files, web browser caches, error logs, and other unnecessary system files are created. This slows down your PC which might lead to some applications freezing or even crashing.
To tweak your computer back to its former glory, Auslogics BoostSpeed does more than just cleaning your files. The tool repairs your Windows registry, disables unneeded programs, secures your system from hackers, and even scans and fixes issues in your hard drive.
As a result, your computer’s performance improves incredibly and you can enjoy a smooth and optimized system.