This is the difference between the two options under the “Clear” button. If you choose the option “Remove Hyperlinks” in the menu, the hyperlink will be removed immediately.Īnd at the same time, the format will also disappear.Here you can choose whether you want to leave the format or not. If you click the button, you can see a submenu with two options. However, the format will still remain.Īnd you will see a small button near the target cell. Here if you click the option “Clear Hyperlinks” in the menu, the hyperlink will be removed from the cell.And then in the drop-down menu, there are two options relating to hyperlinks.Now click the button “Clear” in the toolbar.

You can use the arrow buttons on the keyboard or you can click and hold the mouse to select the cell. In this method, you will use a feature in the toolbar. Different from the above method, you cannot delete the hyperlinks together for different cells. And the hyperlink in the cell has also been removed. When you click the button “Remove Link”, the window will immediately disappear. Otherwise the button of “OK” will be invalid. Remember here don’t clear the hyperlink in the “Address” text box. In the “Edit Hyperlink” dialog, click the button “Remove Link”.And then choose the option “Edit Hyperlink”.

In this method, you can remove hyperlinks in the “Edit Hyperlink” window. Method 2: Remove in the Edit Hyperlink Window Besides, you can also select the two cells together and use this method to remove hyperlinks together. Therefore, you can repeat the steps and remove hyperlinks for other cells.

Thus, you have removed the hyperlink of the cell.

And then choose the option “Remove Hyperlink”.

Right click the cell with hyperlink that you need to remove.

In this image below, you can see that there are 2 cells with hyperlinks.Īnd now you can follow the below 3 methods to remove those hyperlinks. In this article, we will introduce 3 practical methods to remove hyperlinks in Excel cells. Sometimes you need to delete hyperlinks in Excel.

How to disable links in excel 2010