Tutorial s on How to remove all hyperlinks in Microsoft word and Excel

If this is your first time to do this stuff you don't need to worry about it, it's really very easy to do it...

Now for removing the hyperlinks in MS OFFICE WORD what you need to do

With the help of Macros.

Just follow some simple steps given below and see the magic.

  • Open your MS word Document.
  • Press "Alt+F11" - it will open the Visual Basic Editor
  • Click Insert on Menu bar
  • Click Module
In the new pop-up window copy following:

Sub RemoveHyperlinks()
Dim oField As Field
For Each oField In ActiveDocument.Fields
If oField.Type = wdFieldHyperl
ink Then
nd If
Set oField = Nothing
End Sub

Then click File and Close and return to Microsoft Word

After that Run Macro -
Tools > Macro > Macro and then Run “RemoveAllHyperlinks”

For the excel documents:

Remember that in Excel Document. it's a little different.

Open Excel spreadsheet that you want to remove the hyperlinks from. Press -F11 to go to the Visual Basic editor. Create a new module. You can do this by selecting Module under the Insert menu.

Copy and paste the following in new module:

Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
End Sub

Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the File menu.

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