Remove All Hyperlinks in Microsoft Word or Excel

Word

1. CTRL+A and then CTRL+SHIFT+F9

2. Credit to http://www.tech-recipes.com/rx/1323/remove-all-hyperlinks-in-word-or-excel/

Go to “Insert” > “Module” and in the pop-up window copy:


Sub RemoveHyperlinks()
Dim oField As Field
For Each oField In ActiveDocument.Fields
If oField.Type = wdFieldHyperlink Then
oField.Unlink
End If
Next
Set oField = Nothing
End Sub

Then click “File” > Close and return to Microsoft Word

You can now run the Macro in Word by going to:

Tools > Macro > Macro and then Run “RemoveAllHyperlinks”

Excel

You can do the same in an Excel Document:

Hit [ALT]+[F11] to open the Visual Basic Editor

Go to “Insert” > “Module” and in the pop-up window copy:

Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub

Then click “File” > Close and return to Microsoft Excel

You can now run the Macro in Excel by going to:

Tools > Macro > Macro and then Run “RemoveAllHyperlinks”, this will delete all URLS on the selected worksheet.

Comments

comments

Recent Posts
  • Miche

    Alternatively, if it’s one column or 1 row, you can copy and (in another column/row) use ‘paste special’ (Values). Then cut/paste the new column over the one with links.

    • True, but when you have a sheet full of links it can get very cumbersome. This is meant to affect all hyperlinks at once.