![]() Initially, choose the C5:C13 range of cells > hit the CTRL + C keys.So, let’s have a look at the process in the steps below. Read More: How to Remove Hyperlink Permanently in Excel (4 Ways)įor our third method, we’ll apply the Paste Values option to remove hyperlinks from multiple cells at once. Then, select the Multiply option > click the OK button.įinally, your result should look like the picture shown below.Now, this opens the Paste Special wizard. Next, select the C5:C13 cells > hit the CTRL + ALT + V keys on your keyboard.First and foremost, type 1 in the adjacent E5 cell > press the CTRL + C keys.The process is simple and easy, therefore, just follow along. Read More: How to Remove All Hyperlinks in Excel (5 Methods)Īnother handy way to eliminate hyperlinks in Excel involves using the Paste Special feature. To begin with, select the C5:C13 cells > Right-click the mouse to open the Shortcut Menu > choose the Remove Hyperlinks option.Īfter completing the step, all the hyperlinks should be gone, as shown in the image below.Luckily, you may apply the previous method to remove hyperlinks from a range of cells, hence, let us see the process in detail. That’s it, you’ve removed the hyperlink from the C5 cell. Now, Right-click on the mouse to bring up the Shortcut Menu > choose the Remove Hyperlinks option.In the first place, go to the cell from which you want to remove the hyperlink.If you want to remove a single hyperlink within a cell, you can follow the steps shown below. Here, we have used Microsoft Excel 365 version, you may use any other version according to your convenience. Here, the dataset shows the Names of the clients and their Email addresses respectively. So, let’s see it in action.Ĭonsidering the List of Clients dataset shown in the B4:C13 cells. ![]() We’ll begin with the simplest and most trendy way to remove hyperlinks simply, we’ll use Excel’s built-in Remove Hyperlink option. Method-1: Using the Remove Hyperlink Option However, I find this feature to be a nuisance rather than beneficial hence, without further delay, let’s see each of the methods to eliminate hidden links. Excel instantly creates a clickable hyperlink whenever you enter an email address or URL in a cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |