Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, and 2013. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Getting Rid of Many Hyperlinks.

Getting Rid of Many Hyperlinks

by Allen Wyatt
(last updated September 13, 2014)

6

Do you create documents by pasting information that was copied from the Internet? This is not unusual for some people, as there is quite a bit of public-domain information that can be copied from the Internet. When you paste your information into a document, you may notice that there are quite a few hyperlinks in your documents. What if you want to get rid of those hyperlinks?

There are several ways you can approach this problem. One of the easiest ways is to simply change how you paste your information. If you do a simply Ctrl+V to paste, then Word tries to retain as much of the formatting and other attributes of the original text as it can, including hyperlinks. (This is not to say that hyperlinks are strictly formatting; they are not. They are really fields—but more on that in a moment.)

Instead of pasting using Ctrl+V, use Paste Special to paste Unformatted Text. (You use Paste Special by displaying the Home tab of the ribbon, clicking the down arrow under the Paste tool, and then choosing Paste Special.) Word then inserts the information as plain text, without any formatting. It also does not make hyperlinks active in the document. After pasting in this method, you can proceed to format the text as you want.

Another solution is to convert all the hyperlinks to regular text. After doing your paste, press Ctrl+A to select the entire document and then press Ctrl+Shift+F9. As mentioned earlier, hyperlinks are implemented through the use of fields. If you press Ctrl+Shift+F9, then any selected fields are converted to their results and the fields are removed. Thus, the hyperlinks are removed.

There are two drawbacks to this approach. First, not only are the hyperlinks removed, but so are all the other fields in your document. (If you have other fields, you should understand that they will be affected, as well.) The second drawback is that the formatting of your hyperlinks is still there—they show as blue and underlined.

The first drawback is easy to compensate for, provided you don't mind using a macro. The following macro quickly removes all hyperlinks in a document, without affecting any other fields:

Sub KillLinks()
    Do Until ActiveDocument.Hyperlinks.Count = 0
        ActiveDocument.Hyperlinks(1).Delete
    Loop
End Sub

Even after running the macro, the formatting issue still remains—they hyperlinks are formatted as blue and underlined. You can get rid of the formatting by using the Find and Replace feature of Word, but how you use it depends on how the hyperlinks were created.

When you are typing in a document and you type some sort of recognizable electronic address (an e-mail address or a URL), Word automatically formats the address using the Hyperlink style. In that case, you can search for any text using the Hyperlink style, and replace it without the Hyperlink style. (Remember—this doesn't remove the hyperlink, just the Hyperlink style.)

When you paste information in a document, the hyperlinks are formatted differently; Word doesn't use styles to format them. Instead, it formats the hyperlinks explicitly as blue and underlined. In this case, you need to search explicitly for blue and underlined text and replace it with text that is not blue and not underlined.

Note:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (13244) applies to Microsoft Word 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Word here: Getting Rid of Many Hyperlinks.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Protecting a Single Worksheet

Excel allows you to protect your worksheets easily—and that includes if you need to protect only a single worksheet ...

Discover More

Selectively Importing Records

Want to easily control which records get imported from a text file into Excel? It's easy to do when you write the macro ...

Discover More

Getting Rid of the Ctrl+Click Message

When you add a hyperlink to a document, you can later click that link to display whatever is linked to. Well, you ...

Discover More

Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!

More WordTips (ribbon)

Creating a Hyperlink to a Specific Page

Most people add hyperlinks in a document to reference pages on the Web. You can, however, create hyperlinks to other Word ...

Discover More

Pasting a Hyperlink

When you paste information into a document, you can specify that it be inserted as a hyperlink rather than as normal ...

Discover More

Closing Documents after a Hyperlink

When you click a hyperlink that takes you to another document, Word dutifully opens the new document in its own window. ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is seven less than 8?

2018-03-24 17:39:58

Paul Dalton

Allen -While looking for a solution to a recurring problem I've had when copying web articles and then reformatting them for easier reading. I found your article above and initially thought your macro in it would meet my needs. But as I looked at it more closely, using that macro actually will create even more problems for my documents. When accumulating research on a topic, I copy many web articles, then reformat and print them so I can read them better than I can on my computer screen. Almost every time I do that, I find that the article invariably includes TWO types of hyperlinks: Those I DO want to keep as hyperlinks in the article (such as those that link to another piece of related information) and several (or many) hyperlinks (that are usually repetitive through the document) that I want to completely eradicate from the document. Those I don't want will have display text such as ' Return to Top' or 'Next Page' or '(reply )'.(the latter being frequently found in in the 'comments' section at the end of an article, which I usually copy, as well). It is a tedious chore to read through the document just to find, select, then delete each occurrence of these sorts of hyperlinks. What I desire is the ability to (1) highlight (or type in) the specific displayed text of the UNdesired repetitive hyperlink, then (2) have a the facility (whether a macro or through using an existing Word command I didn't know about, or otherwise) that will find and remove all instances of that specific hyperlink (the link, its display text, everything about it) throughout the document. I just couldn't figure out how to make Word do this. Initially, I tried "Find and Replace", but I quickly learned that it doesn't "see" the display text of a hyperlink, as it returns a 'Not Found." Not knowing what to try next, I googled the topic and didn't find anything that specifically addresses this issue. I initially thought I had succeeded when I found your article above and its macro, as I thought I might be able to use it, then use Find & Replace to locate the specific display text, and then (perhaps using wildcards?) remove that display text along with the other now visible text comprising that hyperlink throughout the document. But, after more carefully reading your article, I now understand that using your macro would go much farther than I need and almost certainly would irreversibly change a whole array of things I wouldn't have wanted changed (ALL hyperlinks plus anything else in the document that happens to be in a field). Among the comments under your article, it looked like perhaps Rick Irwin's macro might be modified to do what I need, but - if it can - I don't know how to do it. The only other information I found that looked like it might be helpful was at https://www.datanumen.com/blogs/find-change-delete-hyperlinks-word-document/, but after reading through it, I don't believe those suggested techniques will help me accomplish what I need done. Do you have any suggestions for how I can accomplish finding and removing (or maybe also 'replacing') all instances of the same specific hyperlink in a document regardless of how many times it occurs in a Word document?Thank you,Paul


2017-12-23 01:34:49

Marco Nadal

This doesn't work in Microsoft Publisher 2010; I get an error message:

Compile error:

Method or data member not found


2015-03-17 17:37:48

lemmy caution

"Another solution is to convert all the hyperlinks to regular text. After doing your paste, press Ctrl+A to select the entire document and then press Ctrl+Shift+F9. As mentioned earlier, hyperlinks are implemented through the use of fields. If you press Ctrl+Shift+F9, then any selected fields are converted to their results and the fields are removed. Thus, the hyperlinks are removed."

This is beautiful. This just saved me from a fricking nightmare.


2014-09-16 07:09:55

Rick Irwin

I so the following macro to remove hyperlinks, color and underline.
Sub RemoveHyperlinks()
' Removes the hyperlink the color and underline

Dim oField As Field
For Each oField In ActiveDocument.Fields
If oField.Type = wdFieldHyperlink Then
oField.Unlink
End If
Next
Set oField = Nothing
Selection.WholeStory
Selection.Font.Color = wdColorAutomatic
Selection.Font.Underline = wdUnderlineNone
End Sub

End Sub


2014-09-15 00:07:15

Phil Reinemann

I have a Word macro that handles this much better... I've used it since Word 2003 or before. Put some or all of this in a macro:

If Selection.StartIsActive Then
Selection.Delete
End If
Selection.PasteSpecial DataType:=wdPasteText

That last part (the actual pasting) is one line of adjacent characters except for a space between ...Special and DataType. (I only mention that because this comment box is so narrow it wraps.) Deleting what was there is because I'm often replacing selected text. If you have your caret (mouse pointer) between two characters the text is inserted (assuming you don't have overwrite turned on).


2014-09-13 10:57:51

Michael (Micky) Avidan

As a fair disclosure only - you may "save" one key by using the keys combination: Ctrl+6.
(The key "6" on the horizontal keyboard digits line)
Michael (Micky) Avidan (MVP - Excel)
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.