Removing Hyperlinks from a Worksheet

April 18, 2002 - by Bill Jelen

Mel asks:

Is there a way to remove multiple (900) hyperlinks? I would like to retain the data, but not have it as a hyperlink. I would also like to accomplish in groups or all at once, rather then individually.

In Excel 2002:

• Highlight all the cells.
• Right click, select hyperlink from the pop-up menu.
• Click the Remove button.

In Excel 2000 they did not offer this functionality. You could do it with VBA:

Sub RemoveHyperLinks()
	Range("A2:A999").Hyperlinks.Delete
End Sub