MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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