Remove All Hyperlinks in Word or Excel

These two nifty macros enable you to delete the embedded hyperlinks that are generated when typing URLS or copying information from the web.


Have you ever copied and pasted something from the Internet and then into Word only to get the hyperlinks embedded? You can removed them easily with the Macros below.

Word

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

Go to Insert > Module, and in the pop-up window copy the following:

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 running RemoveHyperlinks.

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 running RemoveHyperlinks. This will delete all URLS on the selected worksheet.

The Conversation

Follow the reactions below and share your own thoughts.

177 Responses to “Remove All Hyperlinks in Word or Excel”

  1. October 19, 2008 at 5:13 pm, Anonymous said:

    Very good.
    Have been attempting to find a solution for some time.
    This macro cleared all links in a very large file at the first attempt.
    Dehkay

    Reply

  2. October 28, 2008 at 9:41 pm, fhff said:

    Awesome!!!!!!! saved me so much time lol thanks

    Reply

  3. October 29, 2008 at 3:09 am, James said:

    very nice! thanks for the tip!

    Reply

  4. November 04, 2008 at 7:42 pm, Scott said:

    THANK YOU! 1 Million ties thank you!!

    Reply

  5. November 05, 2008 at 8:50 pm, Umer said:

    Awesome work, after learning such thing, I feel like a geek ;-)

    Reply

    • May 24, 2010 at 9:35 am, samir said:

      Hello Umer

      Reply

    • May 24, 2010 at 9:35 am, samir said:

      Hello Umer

      Reply

      • June 18, 2010 at 12:24 pm, Umir said:

        Hello Samir

        Umir

        Reply

        • April 13, 2012 at 7:45 am, Junaid said:

          > It’s Very simple

          1 Copy the row

          2 Then Paste Special

          3 Then click values

          then all hyper link will gone …

          Reply

          • September 19, 2013 at 4:01 pm, Michael said:

            “then all hyper link will gone …”

            ALL previous formatting will also be gone using this method.

  6. November 06, 2008 at 8:45 am, Student said:

    Select the entire block of text, then press Ctrl-Shift-F9. Presto: No more hyperlinks. In their place, plain text.

    Reply

    • December 04, 2008 at 1:30 pm, Shivshanker Cheral said:

      Also by presssing Ctrl + 6 we can do this!

      Reply

    • June 21, 2010 at 9:50 am, nora said:

      Ctrl-Shift-F9!
      IT WORKS!
      Elegant simple and it works!
      THANK YOU STUDENT PERSON!!!

      Reply

  7. November 10, 2008 at 7:22 am, Will said:

    Wow, very helpful! Thank you!

    Reply

  8. November 11, 2008 at 7:46 am, gurinder said:

    thanks …

    very very nice.. was so easy with your help

    gurinder singh

    Reply

  9. December 04, 2008 at 1:33 am, agun said:

    owo great …. thank u …

    Reply

  10. December 04, 2008 at 1:57 pm, Shivshanker Cheral said:

    you can remove hyperlink using Ctrl+6 also

    Reply

    • August 20, 2010 at 9:03 am, Powers_100 said:

      with this I am unable to remove hyperlinks of Java Script

      Reply

  11. December 07, 2008 at 11:07 am, Nishant said:

    Hey
    I ran the above macro during a term paper that i was working on, in MS Word 2007.
    Works great – removed all the hyperlinks….
    Thanks ALOT!!

    Reply

  12. December 17, 2008 at 6:40 pm, john said:

    Very useful to me. Thank you so much :D :D

    Reply

  13. December 18, 2008 at 2:08 am, Blandoo said:

    Somehow this does not work for javascript embedded within a picture (buttons). Please let me know if there is a “Remove all Javascript” macro I can run.

    Thanks

    Reply

    • April 22, 2009 at 6:15 pm, Najen said:

      Hi here is code to remove all shapes which include objects ActiveX controls (Control Toolbox) or a linked or embedded OLE objects,Controls from the Forms toolbar
      ,Controls from the Drawing toolbar,Pictures, chartsactive x,buttons,pcitures,drop down lists etc.It will basically remove all these objectsActiveX controls. even cell comments but not cell comments

      Code:

      Sub Shapes1()
      ‘Delete all Objects except Comments
      On Error Resume Next
      ActiveSheet.DrawingObjects.Visible = True
      ActiveSheet.DrawingObjects.Delete
      On Error GoTo 0
      End Sub

      Reply

  14. December 20, 2008 at 1:57 pm, Rusty said:

    Worked like a charm for removing all hyperlinks – thanks

    Reply

  15. December 22, 2008 at 8:48 pm, sil said:

    Many Thanks for this help, Muchly appreciated

    Reply

  16. January 16, 2009 at 5:51 am, me said:

    ok.. it works… thanks a lot.. i’ve been loocking for this.. just not hard enough until now because i didn’t have that much text copied.. it actually took me 2 minutes to find this… and it’s great.. and u actually don’t need to know anything.. just follow the easy instructions

    Reply

  17. January 20, 2009 at 11:49 am, shabi said:

    it’s really very good

    Reply

  18. January 26, 2009 at 6:29 am, Dan said:

    In Office 07 for words. The macro section is under the “view tab” to the far right.

    Reply

  19. February 12, 2009 at 2:08 am, orpheus said:

    Thank you very much. It’s very useful.

    Reply

  20. February 19, 2009 at 5:29 pm, tabi said:

    This didn’t work for me…maybe a problem with Excel 2007? Or my stupidity, it’s tough to say.

    Reply

  21. March 15, 2009 at 2:46 pm, CasuaL said:

    Great work, thanks a lot :)

    Reply

  22. March 28, 2009 at 12:17 am, Bob said:

    Excellent – saved me having to remove 700+ hyperlinks by hand.
    Super huge thanks

    Reply

    • August 20, 2012 at 11:18 am, Anuj Singhai said:

      Thank you very much. It’s very useful.

      Reply

  23. April 11, 2009 at 5:44 am, Sridhar said:

    Marvellous

    Reply

  24. April 17, 2009 at 12:05 am, Jason said:

    Damn Nice!
    Thank you so much.

    Reply

  25. April 21, 2009 at 8:29 am, sasikanth said:

    it nice it working thanks

    Reply

  26. April 23, 2009 at 2:13 pm, prasad said:

    very very very very very thanks

    Reply

  27. May 01, 2009 at 4:27 am, Johnny said:

    Thank you very much.
    Made my life a whole lot easier. =D

    Reply

  28. May 05, 2009 at 1:34 pm, Anji said:

    THANKS that’s great! Saved me precious time. Worked on my mac too.

    Reply

  29. May 12, 2009 at 5:44 pm, k said:

    gr8! saves me a lot of time.

    Reply

  30. May 27, 2009 at 9:04 am, Andy McDandy said:

    Thanks a lot..great help

    Reply

  31. June 15, 2009 at 1:53 pm, Prashanth said:

    just copy to notepad and paste it back!

    Reply

  32. June 16, 2009 at 8:24 am, adam said:

    I have been ALWAYS looking for this.

    Didn’t know I’d ever FIND it, just by googling. Congrats. GREAT CODE!

    Reply

  33. July 01, 2009 at 11:43 am, ivica said:

    TNX

    Reply

  34. July 10, 2009 at 3:41 pm, nox13666 said:

    Thanks, this worked

    Reply

  35. July 20, 2009 at 1:32 pm, Anonymous said:

    how to enable hyperlink, after removing it using VB..?

    Reply

  36. August 16, 2009 at 5:30 pm, Kevin said:

    Thank you for your help. This is a command that Microsoft clearly forgot to add. Great job! Although I have written plenty of macros (mostly on Excel, but a few in Word), I was not excited about adding to my already large set of macros… but I’m glad that I did. It works perfectly!

    Thanks

    Reply

    • October 07, 2009 at 5:21 am, Anonymous said:

      i need macro programs pls send your macros what u have.
      tks

      Reply

  37. August 27, 2009 at 8:05 pm, Heather Arndt Anderson said:

    God, thank you! This is so clean and direct, without entering a bunch of dummy data to sidestep the problem. Thank you so much.

    Reply

  38. September 09, 2009 at 4:55 am, ADTC said:

    There’s another tip that says to select all text and clear formatting. But this makes it lose formatting.

    I found yet another way, just select some normal text in the paragraph and click the Format Painter. Then select all the text where you want hyperlinks removed. The text retains most of the formatting (except when it disagrees with the original text selected before clicking Format Painter).

    Reply

    • October 07, 2009 at 5:19 am, Anonymous said:

      yes its also working good
      thanks dear

      Reply

  39. September 16, 2009 at 1:17 am, Vanessa said:

    OMFG thx u! it works! i am soooo hppy! :D

    Reply

  40. October 06, 2009 at 2:06 pm, Anonymous said:

    Adding another thank you to the list!

    Reply

  41. October 07, 2009 at 5:17 am, Anonymous said:

    Very Very Thanks

    Reply

  42. November 03, 2009 at 8:22 pm, Jay said:

    Thank You, this worked like a dream.

    Reply

  43. November 10, 2009 at 5:06 pm, Anonymous said:

    dude whoever you are
    u rock
    this is excellant

    Reply

  44. November 14, 2009 at 11:25 pm, me said:

    cool. never used a macro before :)

    Reply

  45. November 18, 2009 at 12:12 am, Si said:

    THANKS! This was really handy when pasting Wikipedia articles into Word

    Reply

  46. November 25, 2009 at 4:53 pm, Pirnima said:

    Thank You So much .. my file size has been reduced by half… Thank you really I have been looking for a solution since 3 years!!

    Is there a way where you can can keep the hyperlinks in one column that you want .. and remove it from the rest of the sheet?

    Reply

    • November 25, 2009 at 5:28 pm, ADTC said:

      That’s strange. How do hyperlinks make your file two times bigger? Anyway to selectively remove hyperlinks, I posted the following in a previous comment (2 months ago) for Word:

      —-
      There’s another tip that says to select all text and clear formatting. But this makes it lose formatting.

      I found yet another way, just select some normal text in the paragraph and click the Format Painter. Then select all the text where you want hyperlinks removed. The text retains most of the formatting (except when it disagrees with the original text selected before clicking Format Painter).
      —-

      As for Excel, you can try the second way there too! Just select a cell with normal text, then click (or double-click if you want to do multiple times) the Format Painter, then select the columns with hyperlink that you want removed. Remember that all the selected columns will have the same formatting as the original cell you selected.

      Well apparently I discovered that in both Word and Excel, it doesn’t actually remove the hyperlink but only make the formatting of the link similar to the normal text you selected. This means the links no longer look like links anymore (it looks like normal text now), but when you click on it, it still launches your browser to navigate to the link address.

      Reply

  47. December 18, 2009 at 1:56 pm, Anonymous said:

    Thanks for the help. It helped me & saved my time.

    Reply

  48. December 28, 2009 at 4:14 pm, Humza Bobat said:

    Very Useful Stuff :-)

    Reply

  49. December 30, 2009 at 1:14 pm, Anonymous said:

    i don’t know delete hyperlink in Microsoft Office Word 2003

    Reply

  50. January 03, 2010 at 2:56 pm, Anonymous said:

    I just wanted to ad something if one wants to use the same with Office 2007 or later.
    The procedure is just the same but in order to execute it we need to click on office button, then change the Popular Commands Drop Box to Macros.
    Click on the remove…..
    Add>
    Done!

    Reply

  51. January 04, 2010 at 9:04 pm, Anonymous said:

    Or…select all the text and press CONTROL+6

    Reply

  52. January 15, 2010 at 7:19 pm, Tom said:

    Thanks for the MS word solution. I couldn’t figure out how to get rid of those stupid hyperlinks. Very greatful.

    Reply

  53. January 15, 2010 at 7:19 pm, Tom said:

    Thanks for the MS word solution. I couldn’t figure out how to get rid of those stupid hyperlinks. Very greatful.

    Reply

  54. January 18, 2010 at 5:29 pm, Anonymous said:

    THANK YOU X 100000000000000000000000000000000000000000000. I had over a week long work load of deleting these and this did it in seconds!!!!!!!!!!

    Reply

  55. January 22, 2010 at 4:33 pm, Jim said:

    My only question is, why isn’t this option in the program to begin with? Answer: Microsoft.

    Reply

  56. February 04, 2010 at 5:37 am, A.D.E.Cyber Emporium said:

    Thanks for the info.
    Saved heaps of time and was so easy to do.
    A+

    Reply

  57. February 17, 2010 at 12:55 am, Research said:

    In MS word

    select all [CTRL + A]
    then CONTROL + SHIFT + F9. …

    NO NEED FOR VBA… Simple and fun….

    Reply

  58. February 18, 2010 at 6:37 am, Mike said:

    Thanks worked great…..the first time, when i tried it a second time it went all grey, i couldnt paste the information into another word document or anything. A bit anoying :-(

    Reply

  59. February 25, 2010 at 12:53 am, BentSpork said:

    Great code, but it doesn’t go into the footnotes. here is code for footnotes using the Selection approach:

    ActiveWindow.ActivePane.View.SeekView = wdSeekFootnotes
    ‘ Select all text in the footnotes.
    Selection.WholeStory
    ‘ Loop through fields in selection.
    For Each aField In Selection.Fields
    ‘ If field type is a Hyperlink field.
    If aField.Type = wdFieldHyperlink Then
    aField.Unlink
    End If
    Next aField
    ‘ Close Footnotes and return to document
    ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument

    Reply

  60. March 01, 2010 at 2:53 pm, adam page said:

    Thanks for this :)

    Reply

  61. March 07, 2010 at 3:08 am, Anonymous said:

    thank you dost.

    Reply

  62. March 18, 2010 at 6:56 am, VIKI said:

    WOW REALLY GREAT TIP….. I WAS SEARCHIN FOR THIS TIP

    Reply

  63. March 30, 2010 at 3:38 pm, Anonymous said:

    AWESOME !!!! You saved my whole day !!!

    Reply

  64. April 14, 2010 at 2:48 pm, Anonymous said:

    It was awesome!! This perfectly works for me!! I have one doubt. Will this changes reflects in other system which doesnt have macros.

    Thanks,
    Krithika

    Reply

  65. April 15, 2010 at 12:33 pm, Laptop Repairs said:

    That saved me like 4 hours of workload. Can’t tahk you more. Thanks a bunch~!

    Reply

  66. April 22, 2010 at 9:57 am, Anonymous said:

    Thank You…. works a treat

    Reply

  67. April 30, 2010 at 4:24 pm, ashley said:

    I want it to not paste as a hyperlink in any document. I don’t want to have to remove them in each document.

    I know how to copy a #1 and hold control and select all the links I want to disable and paste special and choose multiply to make all links go away. Then I have to reformat the text to match surrounding text. (change from blue to black and remove underline)

    Reply

  68. May 04, 2010 at 6:19 pm, mickey said:

    It’s a beautiful thing. Thanks so much…

    Reply

  69. May 06, 2010 at 4:13 pm, Anonymous said:

    This helped me no end with a big problem I was having on some huge spreadsheets! Thank you very much

    Reply

  70. May 13, 2010 at 10:17 pm, Larry Orr said:

    What versions of Work and Excel are you talking about? Are these Windows or Mac commands? In other words, more info is needed.

    Reply

  71. May 25, 2010 at 12:02 am, nick said:

    made my day, saved my ass, thanks

    Reply

    • July 20, 2010 at 7:52 pm, Ambatirajaraviteja said:

      superrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr

      Reply

  72. May 29, 2010 at 11:54 am, Henri said:

    Thank you

    Reply

  73. May 31, 2010 at 8:48 am, Lune said:

    Thanks a lot!

    Reply

  74. June 10, 2010 at 5:48 pm, Scott said:

    Awesome – thanks!

    Reply

  75. June 21, 2010 at 9:17 am, Aakarsh said:

    very gud post
    thnx for the information

    Reply

  76. June 24, 2010 at 10:15 am, Ishaan said:

    One new IDEA!!!!!
    Press Ctrl+6
    And all the links will disapear in a second

    Reply

  77. June 24, 2010 at 5:53 pm, Ishaan said:

    One More Ctrl+Shift+F9

    Reply

  78. June 25, 2010 at 2:12 pm, Irina Eastwood said:

    Amazing! Very straight forward. Thanks guys! It worked

    Reply

  79. July 02, 2010 at 7:19 pm, Suzym27 said:

    But how do I do this on a MAC?!?!

    Reply

    • July 02, 2010 at 7:24 pm, Suzym27 said:

      Figured it out!

      Control + A to select all
      Control + 6 to clear all hyperlinks

      Fantastic!

      Reply

  80. July 03, 2010 at 8:54 am, Jhasgdas said:

    thank you very much bro…

    Reply

  81. July 27, 2010 at 10:17 pm, Juicylicious said:

    Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you!!!!!!!!!

    Reply

  82. July 29, 2010 at 11:01 am, Ajith Moharana said:

    super class coder – a lot of thanks

    Reply

  83. August 02, 2010 at 12:12 pm, Clarkygal345 said:

    For word, press CTRL + A to select all, then press CTRL, Shift + F9.
    Shortcut to get rid of all hyperlinks :)

    Reply

  84. August 04, 2010 at 4:15 am, Futbolamanda said:

    YAY you are SOOOOO helpful. Thanks heaps! Really, it is a revelation. I hated those hyperlinks!

    Reply

  85. August 04, 2010 at 9:02 pm, Guest said:

    Click ‘file’ in Excel 2007??? Are you kidding me?

    Reply

  86. August 09, 2010 at 10:03 am, dotaplayer said:

    I love ya oh yes

    Reply

  87. August 11, 2010 at 2:39 pm, Veb_405 said:

    this trick is so helpful to remove Hyperlinks with one click

    that`s awosome!!!!!!

    Reply

  88. August 13, 2010 at 4:06 am, Liz said:

    This is awesome. You rule. Thanks.

    Reply

  89. August 18, 2010 at 2:36 pm, mujnoo said:

    You are FABULOUS!!!
    why is this solution not available in the Excel help????
    thank you so much.

    Reply

  90. August 20, 2010 at 11:14 am, Soanis said:

    For Office for Mac its cmd + 6 (that’s the command button near the spacebar + 6) when a text is selected.

    Reply

    • November 13, 2010 at 3:22 pm, nebo said:

      This works for MS Word for Mac – i.e. cmd+6. Thank you.

      Reply

  91. August 25, 2010 at 4:16 am, Nana said:

    Thank you so much!

    Reply

  92. August 25, 2010 at 5:43 pm, Bretv72 said:

    Oh thank you, thank you. I have a weekly document that I used to spend an hour on just removing copied hyperlinks!

    Reply

  93. September 13, 2010 at 4:14 pm, S2c said:

    or you could select the text and press control+shift+f9

    Reply

  94. September 15, 2010 at 7:20 pm, Prostreetphotography said:

    WHERE are the Tools > Macro > Macro tabs? I don’t see them in any menu at the top of my Word document. I copied everything above into a macro, but can’t seem to find any of the tabs I need to click on after that. Help! This sounds like such a great idea if I can figure it out.

    Reply

  95. September 15, 2010 at 7:24 pm, Prostreetphotography said:

    OMG! Thanks, S2c! YOUR trick worked instantly! I’ll have to remember that one!

    Reply

  96. September 17, 2010 at 7:15 am, Harris David said:

    Wahhh…good dude..this is what i searched a lot…thx

    Reply

  97. September 22, 2010 at 4:33 am, D Arumugam said:

    thanks for your help

    Reply

  98. September 26, 2010 at 11:14 pm, Vickythakre said:

    Many Many Thanks buddy

    Reply

  99. September 30, 2010 at 12:42 pm, Jelena said:

    Many thanks from Jelena N, Belgrade, Serbia

    Reply

  100. October 04, 2010 at 2:11 pm, Mrix2 said:

    Thank you very much!!

    Reply

  101. October 06, 2010 at 1:26 pm, jeremey said:

    EXCELLENT! THANK YOU SO MUCH!

    Reply

  102. October 06, 2010 at 6:09 pm, Dhas said:

    How about pressing CTRL+A then CTRL+SHIFT+F9?

    Reply

  103. October 10, 2010 at 8:59 am, R Andrew025 said:

    ThankS alot!

    Reply

  104. October 24, 2010 at 3:26 pm, 123 said:

    Good one

    Reply

  105. October 24, 2010 at 3:27 pm, ASHRAJ2204 said:

    THANKX

    Reply

  106. October 26, 2010 at 2:28 am, Joe said:

    Thank You very much. It helps.

    Reply

  107. October 27, 2010 at 10:12 am, Shashank TM said:

    Thank you so much it helped me lot

    Reply

  108. November 17, 2010 at 6:23 pm, Leo said:

    Thanks, for a while i’ve been looking for something to remove hyperlinks in excel. I knew that CTRL+Shift+F9 removes them in word. Keep up the good work

    Reply

  109. November 19, 2010 at 6:56 pm, Neeraj Tiwari said:

    there is no tools option in microsoft word 2010 .. i m stuck after copying the macro…please help….

    Reply

    • January 13, 2011 at 10:26 pm, Ceci said:

      same here! please!

      Reply

  110. December 26, 2010 at 9:14 am, Nemanie Dem said:

    Awesome! You saved my day)

    Reply

  111. December 26, 2010 at 9:15 am, Nemanie Dem said:

    Awesome! You saved my day)

    Reply

  112. December 29, 2010 at 10:04 pm, Mav786110 said:

    amazing history project aced

    Reply

  113. December 31, 2010 at 8:12 am, V P said:

    outstading !!!!!!!!!!!!!!!!!!!!

    Reply

  114. January 25, 2011 at 8:25 am, Dilpreet Singh said:

    When i save the marco it works but is there any way it should remain saved in excel permanently…..whenever i open an excel file it should automatically be saved.

    Reply

  115. January 28, 2011 at 5:43 am, Linknumbernine said:

    you are an angel. I love you

    Reply

  116. February 14, 2011 at 8:38 pm, Thenassa said:

    thank u. it was really helpful.

    Reply

  117. February 19, 2011 at 2:35 pm, Spooky said:

    Thanks dude! You saved me a lot of time so I didn’t have to remove every single hyperlink manually. I’m sue a lot of folks find this very helpful.

    Reply

  118. April 01, 2011 at 5:00 pm, Guset said:

    Thanks! Very usefull.

    Reply

  119. April 06, 2011 at 10:28 am, Imtiaz said:

    thanks its working goood

    Reply

  120. April 28, 2011 at 5:58 pm, machimocho said:

    excellent tip

    Reply

  121. May 02, 2011 at 7:02 pm, Equinepedestrian said:

    This has proven to be very helpful!

    Reply

  122. June 09, 2011 at 11:12 pm, Anonymous said:

    it works great …. but it doesn’t remove the links from images. Any ideas?

    Reply

    • June 13, 2011 at 10:48 am, JJ said:

      I am also trying to remove links from images… :( not working, please help

      Reply

      • June 15, 2011 at 4:02 am, Anonymous said:

        maybe save it in HTML and then remove the links then paste it into word again

        Reply

  123. October 26, 2011 at 9:54 am, Caidian Johnson said:

    … Thank you very much – Worked a treat! …

    Reply

  124. November 07, 2011 at 3:38 pm, Akhtar Jahan said:

    Perfect. Thanks

    Reply

  125. November 16, 2011 at 2:59 pm, Cindy said:

    THANK YOU – simple and fast.

    Reply

  126. November 21, 2011 at 1:03 am, SRILAKSHMI said:

    Thanks a lot. With this, I have removed all URL data within a few seconds in a very large excel file

    Reply

  127. November 22, 2011 at 5:46 pm, Akhtar said:

    This article realy good.Special thanks to BentSpork. He solved my footnote hyperlink problem.

    Reply

  128. November 22, 2011 at 11:29 pm, sunwukong said:

    I’m looking for a macro that will succesively find each hyperlink, copy that link and then place it in the document (after the linked text) as text.

    Reply

  129. December 02, 2011 at 3:26 am, Marvin said:

    Thank you so much! This is the greatest little gem I’ve found in a long time. At last, some real helpful help.

    Reply

  130. December 28, 2011 at 11:30 am, Paul said:

    Thanks – the other solutions online were not as quick or effective as this macro!

    Reply

  131. January 10, 2012 at 3:41 am, Libor said:

    Thanks! Smart solution.

    Reply

  132. January 31, 2012 at 5:54 am, John said:

    Many thanks – it’s excellent.

    Reply

  133. February 08, 2012 at 10:52 pm, Jon Dray said:

    Look at all the thanks and praise on this topic. I still felt compelled to add mine as well. Those hyperlinks were killing me at my data entry job! Thanks so much for the tip!!

    Reply

  134. February 15, 2012 at 4:11 am, Yesssss!! said:

    THANK YOUUUUUU!!!!

    Reply

  135. February 16, 2012 at 2:07 pm, Josie said:

    Perfect removed 792 Hyperlinks in less than 2 seconds.

    Reply

  136. February 19, 2012 at 2:39 am, Stiofan said:

    Thanks. After trying many other hints that failed, this one does the job.
    Brilliant.

    Reply

  137. February 19, 2012 at 8:08 pm, kevin said:

    Thanks – works well!!!
    Would be good to remove undelirline and blue font too ;)

    Reply

  138. February 19, 2012 at 8:09 pm, kevin said:

    Thanks – worked wel!!

    Reply

  139. February 19, 2012 at 8:09 pm, kevin said:

    would be useful to remove font colour and underline too

    Reply

  140. February 27, 2012 at 3:29 am, Clive said:

    Thanks – very helpful, but on my computer using Word 07, alt-F11 doesn’t bring up Visual Basic but splits the document into two parts. I had to use Developer mode to enter VB

    Reply

  141. March 23, 2012 at 2:11 pm, Gorgeous said:

    Not so bad. Interesting issues here

    Reply

  142. April 18, 2012 at 3:10 am, janet sequeira said:

    i dont recpie source any more pls remove and stop sending any more thank you

    Reply

  143. June 30, 2012 at 7:13 pm, Nick said:

    I am amazed that this seems to have worked so well for so many since I found two major errors, one in the code and another in the text:

    In the code: a CR/LF is required after “Sub RemoveHyperlinks()”, making “Dim oField As Field” the second line. The first line names the macro “RemoveHyperlinks”.

    In the text: The macro is supposed to be executed as follows:

    You can now run the Macro in Word by going to:
    Tools > Macro > Macro and then Run “RemoveAllHyperlinks”

    However, as pointed out, the name of the macro is really “RemoveHyperlinks”

    Reply

  144. July 12, 2012 at 7:58 am, amis said:

    Thank you, It’s very good.

    Reply

  145. July 12, 2012 at 8:08 am, amis said:

    Thank you, It,s very good.

    Reply

  146. August 16, 2012 at 6:12 am, Gopal Singh said:

    hi this is gopal i want remove of image to Microsoft excel

    any one confirm me how to remove image to excel sheet

    Reply

  147. September 18, 2012 at 4:44 pm, Amanda said:

    This is not working for me in excel. I have tons of hyperlinks in empty cells and all this does when I run the macro is freeze up and then I have to close and re-open.

    Any more suggestions?

    Reply

  148. November 08, 2012 at 2:11 pm, misbhavan said:

    Wish it worked. Keep getting errors like “Compile Error. Expected End of Statement” and “Can’t execute code in break mode.” Any suggestions?

    Reply

  149. November 08, 2012 at 10:47 pm, abhishek said:

    I have a very big word document and I want to select all hyperlinks and paste them some where else it is a 40 page document with each page having 10 hyperlinks and paragraphs in between is there a way I can only select hyperlinks

    Reply

  150. December 14, 2012 at 2:17 am, David Kirk said:

    I just tested this in Office Excel 2011 for Mac. The Macro worked like a charm.

    To start the process go to Tools -> Macro -> Visual Basic Editor.

    Reply

  151. January 14, 2013 at 7:56 am, Karan Pathania said:

    Its a lot of trouble. You need not do all this stuff.!!!
    Here is a more simple and easy way:

    1. Press “Ctrl+A”
    2. Press “Ctrl+Shift+F9″

    :) Enjoy !!!

    Reply

    • May 07, 2013 at 12:25 pm, Robert said:

      > Didn’t do a thing in Word 2010.

      Reply

  152. January 30, 2013 at 11:31 am, Thomas said:

    Really nice and easy explanation ! Saved me a lot of time

    Reply

  153. March 11, 2013 at 11:00 pm, sean said:

    Awesome!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Reply

  154. March 25, 2013 at 2:49 pm, Stephanie said:

    Thanks for posting this. It would have taken me hours if I had to remove the links manually.

    Reply

  155. May 07, 2013 at 12:16 pm, Robert said:

    Hi Katy,

    I am using MS Word 2010. This macro would be very useful to me. I have copied yours and followed the instructions, but I cannot find ‘Tools’ anywhere… At the top I have File Home Insert PageLayout References Mailings Review and View. In the View there is a Macros item, but the RemoveHyperlins is not displayed.

    Thanks,
    – Robert

    Reply

  156. May 13, 2013 at 4:20 am, jakcob said:

    thank you, very useful info. works perfectly

    in new excel you just need to add MiCRO from Excel options

    go in Excel Start > on the bottom click Excel Options > Customize > in the botom of the add ons chooce View Macros and click Add then you will see the MACRO link on along with Back and forward buttons and you will tun them quickly

    Reply

  157. December 24, 2013 at 6:08 pm, Khash said:

    I get a compile error: Syntax Error

    Reply

Leave a Reply