Remove Contents Hyperlinks Or Formatting. Cell formatting will be removed also. Select the text from which you want to remove formatting in Word.
This will display all of the Clear methods available to you. To remove a single hyperlink right-click on the hyperlink and select Remove Hyperlink on the popup menu. Would override all link styles and make all the states the colour blue.
You can also right-click the selected range and choose Remove Hyperlinks from the menu see screenshot.
But sometimes we need to keep the cell formatting when removing the hyperlinks. Alternative Method to Remove Hyperlinks in Excel. This will remove a clickable hyperlink but keep the link text in a cell. Calling the ClearHyperlinks method on the specified range is equivalent to using the Clear Hyperlinks command from the Clear drop-down list in the Editing section of the Home tab.