How to remove hyperlinks and turn off automatic links in Excel

In desktop Excel for Windows, right-click a linked cell and choose Remove Hyperlink to keep its visible text. To prevent future links, turn off automatic hyperlink formatting for internet and network paths in Excel’s AutoCorrect settings.

Remove an existing link and keep the cell text

With automatic formatting enabled, Excel may turn a typed web address into a link. Blue underlined text is a common result. The exact appearance depends on the workbook’s styles and theme.

For a single link that was just created, open the small AutoCorrect Options button beside the cell and choose Undo Hyperlink. If you use Ctrl+Z, check that the address is still in the cell. If you’ve made other changes since typing it, use the removal command below.

  1. Select the linked cell without following the link. One way is to move to the cell with the arrow keys from a neighboring cell. Right-click to show the context menu.
  2. Choose Remove Hyperlink. The visible text stays in the cell. Pressing Delete would also remove the cell content.

Check that the URL or label remains. For instance, removing a link labeled Product list leaves that label in the cell. Copy the destination address first if you need to use it later.

For several links, select the cells you want to change and choose Remove Hyperlinks from the context menu. Confirm the selection before using the command on a whole row or column when other links should remain.

Keep the displayed value of a HYPERLINK formula

If the formula bar shows HYPERLINK, the formula itself creates the clickable text. To keep the currently displayed value, copy the cell and use the Values paste option.

Paste to an empty cell first if the formula should stay available. Pasting values over the original cell replaces the formula with its current result, which will no longer update if the source changes.

Microsoft Support guide to removing Excel links and pasting values

Turn off automatic hyperlink creation

  1. Open the File tab on the ribbon.
  2. Choose Options near the bottom of the File menu.
  3. In Excel Options, choose Proofing and open AutoCorrect Options.
  4. On AutoFormat As You Type, clear Internet and network paths with hyperlinks. Leave the other formatting settings as they are unless you want to change those behaviors too.
  5. Choose OK in the AutoCorrect dialog and again in Excel Options to save the change.

Microsoft Support guide to automatic formatting in Excel

Test the setting and turn it back on

Type https://example.com into a fresh blank cell and press Enter. The setting is working if the address remains visible without a new hyperlink. Existing links stay attached, so use a newly typed cell for the check.

This setting covers recognized web addresses, email addresses, and network paths. Select the same checkbox to turn automatic links back on. You can still use the Insert tab to add a link when you need one.