How to remove Excel Hyperlinks?

Question

I have 100 site url's listed in excel sheets and all are hyperlinked and i want to remove hyperlinks from the url's listed in one go, but cannot. I have to select every cell and then right click > remove hyperlink option. But if i select all the files and right click there is no remove hyperlink option.

How can i remove all hyperlinks at one go?

Answer 1

Press Alt-F11 to activate the Visual Basic Editor, select Insert, Module to insert a new VBA module into your project, and then enter the following code:

Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End Sub

When you execute the ZapHyperlinks macro (Alt-F8 to get to the Macro menu), all hyperlinks on the active sheet are deleted and replaced with normal text.

Also, to keep this from happening going forward, go to Tools->Autocorrect Options and remove the checkmark to "Replace as You Type Internet and network paths with hyperlinks".

Answer 2

To turn off several hyperlinks at once, do the following:
In a blank cell, type the number 1.
Right-click the cell, and then click Copy on the shortcut menu.
Hold down CTRL and select each hyperlink that you want to turn off.
select Paste Special.
Under Operation, click Multiply, and then click OK.