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.