How to remove hyperlinks throughout the document in Word and Excel: instructions

If you did not change the settings in Microsoft office programs, when copying or writing text that contains links to Internet sites, hyperlinks appear that can redirect the user directly from the document to the specified site. However, many do not want them to be present in the text, especially since they have distinctive features, such as underline and a different color (blue by default). The article will discuss how to remove hyperlinks throughout the document. We will deal with both the Word text editor and the Excel spreadsheet editor.

Delete hyperlinks through the context menu in Word

The first thing we’ll talk about is how to remove hyperlinks throughout the Word document. The first method presented will be applied using the option from the context menu called by the right mouse button (RMB). It should be said right away that this method is well suited if there are not very many links in the document, since you will have to deal with each of them separately. If you want to learn how to delete all hyperlinks in a Word document at the same time, then proceed immediately to the next method, but in the meantime we will start.

So, let's say that you have a document open in which there are hyperlinks. To remove them, you need to do the following:

  1. Hover over the link.
  2. Click RMB to open the context menu.
  3. In the context menu, select the option "Delete hyperlink".

how to remove hyperlinks throughout the document

After completing these three points, the hyperlink will disappear from the document. As you might guess, to remove all links, you need to do these steps for each individual, which is time-consuming if there are a lot of them.

Delete Hyperlinks Using Hot Keys in Word

You already know how to remove hyperlinks in the entire Word document using the option from the context menu. Now we will talk about the second method, which is significantly different from the first, as it allows you to delete links by pressing a few keys.

So, to remove hyperlinks with hot keys, you need to:

  1. Select the part of the text that contains hyperlinks. If you want to delete all links, then to select all the text it is easier to use the key combination CTRL + A.
  2. Press SHIFT + F9.

delete all hyperlinks in the word document

After performing these simple two steps, absolutely all links in the text will disappear. This method is good in that the formatting of the text does not change in any way after its application.

Insert text without hyperlinks

You already know two ways to remove hyperlinks in the entire Word document, however there is one interesting way that eliminates their formation when copying text from any sources. By the way, the instructions are common for both Word and Excel.

So, to insert text with links in the document so that they do not turn into hyperlinks, you need to:

  1. Put the desired text on the clipboard. To do this, select the text and in the context menu that is called up by RMB, select "Copy" and you can also press CTRL + C.
  2. Open a document.
  3. Click RMB on the sheet or in the desired cell.
  4. From the context menu, select the option "Save only text", which is located in the group of options "Insert Parameters".

how to remove hyperlinks throughout an excel document

After that, the text is inserted into the document, and all hyperlinks disappear. But this method has one drawback: the initial formatting of the text will disappear. However, if in the future you planned to change it yourself, it is perfect.

Delete all hyperlinks in Excel

Finally, let's talk about how to remove hyperlinks throughout an Excel document. And this is done as simple as possible. You need:

  1. Select the cells in which you want to remove hyperlinks (you can also use the CTRL + A keys if you want to select the entire document).
  2. Click RMB on one of the selected cells.
  3. In the context menu, select the "Delete hyperlinks" item.

After that, they will disappear. However, it is likely that this method will not work in earlier versions of the program. The test was conducted in Excel 2010.


All Articles