Table of Contents
In this post, We’ll show you how to Remove Hyperlinks in Excel like an expert and save you a lot of time. There is no doubt that the link is a really beneficial tool. It makes it easy for us to switch to different resources by just clicking on them. These resources can be websites, documents on your computer, or other internet stuff.
But using links when they aren’t needed can be incredibly annoying. If you use it too much, it will make a lot of mess and confusion. By default, Excel turns all URLs and e-mail addresses into links that may be clicked on. This can be incredibly annoying over time, especially if you need to maintain your data clean and in order.
Excel turns URLs that are typed into spreadsheets into links automatically. If you click on the links in the cells, you can open the sites in a browser. But it’s not always best to have links in spreadsheets because clicking on their cells can launch the websites, even when you don’t need them.
Ways to Remove Hyperlinks in Excel
Remove Hyperlinks from Excel
- Select the cell that contains the hyperlink. Do this without navigating to the link by right-clicking the cell and then hitting the Esc (Escape) key to remove the menu that appears when you right-clicked the cell.
- Go to the Home tab and look to the right and click the small white eraser button and then click Remove Hyperlinks.
- That’s it!
Remove All Hyperlinks from a Worksheet at Once
- Click the upper left corner of the spreadsheet to select the entire worksheet.
- Go to the Home tab and look to the right and click the small white eraser button and then click Remove Hyperlinks.
- That’s it!
What is a hyperlink in Excel?
When a user clicks on a hyperlink in Excel, it takes them to a different place. You can add links to cells, which can connect to another cell in the same spreadsheet, a different workbook, or a website outside of the spreadsheet. When you paste a link into a cell and press “Enter” on your keyboard, the cell turns into a hyperlink.
Users can also make links by selecting a cell, picking the “Insert” tab, then clicking “Link.” On this tab, you can choose which document you wish to link to or paste a link to a website outside of Google Docs. You can change the “Text to display” option if you want the cell to show something other than the link’s URL. When you click “OK,” the link shows in the cell. When you click on it, it takes you to a new website.
FAQ
Why can’t I remove hyperlinks in Excel?
You only need to choose the range of cells that have the links. Using Ctrl+A, you can choose the whole sheet or even several sheets at once. Then, right-click anywhere inside the selected cells and choose “Remove Hyperlinks” from the Context menu.
How do you remove hyperlinks but keep formatting in Excel?
Choose Clear Remove Hyperlinks from the Editing group on the Home tab of the Excel ribbon. (see above). Note that this command will get rid of the hyperlinks in the selected cell(s), but it won’t modify the way the cell(s) are formatted.