Daily tips for using Microsoft Excel.

Thursday, April 18, 2002

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

For info about entering a VBA macro, see this page.