Removing Hyperlinks from a Worksheet
April 18, 2002 - by Bill Jelen
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