How To Remove Hyperlink Automatically In Excel

When you copy or input a url or an email address text into excel cell, it will add a hyperlink automatically. Sometimes this is useful, but for most times this is not useful at all. This article will tell you how to remove the hyperlink and how to disable auto hyperlinking in excel settings.

excel url hyperlinking

1. Remove Existing Hyperlinks.

  1. Select one or multiple excel cells which contains hyperlink text.
  2. Right click the excel cell selection area.
  3. Then click the Remove Hyperlink menu item to remove the hyperlink in the excel cell.
    remove excel hyperlink menu item

2. Do Not Add Hyperlink When Paste Url Or Email Text.

  1. Copy a url or email text into clipboard.
  2. Select one excel cell ( do not double click the excel cell to enter input text mode ) where you want to paste the text to.
  3. Right click the excel cell and click the Paste Special menu item in the popup menu list.
    excel paste special menu item
  4. There will popup a dialog. The Paste radiobutton at left side is checked by default, you can select text encoding format at right side. Click OK button, then the cell url text will not contain hyperlink.

    excel paste special text encoding format dialog

3. Disable Excel Auto Hyperlinking Settings.

The reason for auto hyperlinking in excel is because the default settings for auto hyperlinking is enabled. We can disable it to avoid auto hyperlinking when we input more url or email text.

  1. Click File —> Options menu item.
  2. Click Proofing menu item at popup dialog left side.
  3. Then click AutoCorrect Options button at right side.
    excel - file - options - proofing - autocorrect options
  4. Click the AutoFormat As You Type tab and uncheck the Internet and network paths with hyperlinks checkbox, click OK button to save the changes.
    excel - file - options - proofing - autocorrect options - autoformat as you type
  5. Now when you input a url or an email address in excel cell again, it will not add the hyperlink at all.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.