How do I get rid of hyperlinks on Excel documents

If you often use Excel to enter mailboxes and URLs, we know that the software will automatically convert these sites and e-mail addresses to hyperlinks, this function, although very practical, can be very convenient to go to the corresponding URL, but not everyone likes it. For frequently operated files, inadvertently delayed after the Internet Explorer and Outlook and other mail programs, it is annoying. How to disable hyperlinks in an Excel document.

In fact, you can get rid of Excel hyperlinks, so that they become flexible text.

I. Set up Excel so that the software does not automatically add hyperlinks.

After you open Excel, locate the check that you can set in the Tools-> AutoCorrect options, and remove the "Internet and network paths with hyperlinks" front. After that, Excel will not make hyperlinks to the Web site itself.
Two. For documents that have already been added to a hyperlink, remove them with a "copy" return.

If you already have a lot of URLs or e-mail addresses in your Excel document that already have hyperlinks, just select the email address with the hyperlink, right-click and select Copy in the right menu, and then press ENTER, and you can see that the hyperlink has been canceled.

Can also be like the first figure directly click "Undo Hyperlink", in fact, there are many ways to remove hyperlinks, the above method is very simple, also very easy to operate, and still can retain the color of hyperlinks, but in fact he is already text.  Clicking on him is without any reaction. The link has expired.