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

Setting Matrix Row Spacing in the Equation Editor

The Equation Editor is a tool you can use to create complex mathematical formulas and insert them in your documents. If ...

Discover More

Counting All Characters

Need to know how many characters there are in a workbook? You can find out easily with the handy macro introduced in this ...

Discover More

Font Changes when Pasting to Another Document

When you copy information from one document and paste it into another, you may not always get what you expect. If the ...

Discover More

The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!

More WordTips (ribbon)

Adding Hyperlinks

Adding a hyperlink to a text selection is easy to do in Word. All you need to do is make a couple of clicks and specify ...

Discover More

Creating Hyperlinks from E-mail Addresses

Got a document that has a whole raft of e-mail address in it? You can easily convert all of them to clickable hyperlinks ...

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 five more than 3?

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.