Often, you may find yourself working with URLs in Excel spreadsheets. But what if you don’t want to link directly to a website? Let’s learn how to remove hyperlinks in Microsoft Excel.
How to Remove Hyperlinks in Excel
Microsoft Office applications will often automatically convert URL text into hyperlinks, especially when you paste into a document or spreadsheet. While sometimes desirable, in other cases, you may want to remove these hyperlinks. Fortunately, that’s easy to do in Excel. It only takes a few clicks.
Consider a cell containing a hyperlink. Any time you click into the cell, your web browser will be opened and you’ll be taken to the URL contained inside. Imagine that you want to display the URL, but not have it link directly to the site. In other words, you want to be able to click into the cell without launching your browser.
This is where removing a hyperlink in Excel comes in handy. To select the cell – without opening the link – you’ll want to click into any adjacent cell. Then, use the arrow keys on your keyboard to select the cell containing the hyperlink.
Once you have the link-containing cell selected, right-click to open up the dropdown menu. Near the bottom, you’ll see the option to Remove Hyperlink.
Click on this. Excel will leave the text of the URL, but remove the actual hyperlink feature.
To demonstrate, click into the cell containing the URL. Where before it would launch your browser, Excel now treats it like any other text cell in your workbook. This is a great way to display URLs, while avoiding annoying links that take users of your spreadsheet away from your document.
As you can see, Excel makes it easy to work with and remove hyperlinks. It only takes a few seconds.