Document Editing Problems

How to Remove Hyperlinks in Excel on Windows 10 (Fix Missing Option)

Phi Hung Vo Oct 8, 2026 868 views

Question details

The user needs to remove hyperlinks from Excel cells but cannot find the standard option to do so, and keyboard shortcuts are unresponsive.

How to Remove Hyperlinks in Excel When the Option is Missing

Product: Microsoft Excel
Device & OS: Windows 10
Scenario: Attempting to remove unwanted email or web links from spreadsheet cells to format them as plain text.
Observed behavior: The 'Remove Hyperlink' option does not appear in the menu, shortcuts fail, and clicking the cell unexpectedly triggers a mail account setup prompt.

Before you start

To prevent the mail account setup prompt from popping up, use your keyboard's arrow keys to select the hyperlinked cells instead of clicking them directly with your mouse.

Solution 1Recommended

Use the Clear Option on the Home Tab

This is the most reliable method to remove hyperlinks when the right-click context menu fails to display the 'Remove Hyperlink' option.

Excel has a built-in 'Clear' tool located on the main ribbon that can target specific cell attributes, including hyperlinks, without affecting the text data itself.

Select the target cells

Use your keyboard arrow keys to navigate to and highlight the cell or range of cells containing the unwanted hyperlinks.

Navigate to the Home tab

Look at the top ribbon of your Excel window and click on the 'Home' tab.

Locate the Editing group

Find the 'Editing' group on the far right side of the Home tab.

Clear the hyperlinks

Click on the 'Clear' button (often represented by a pink eraser icon) to open the dropdown menu, and select 'Clear Hyperlinks'.

Formatting Tip: Choosing 'Clear Hyperlinks' removes the link but leaves the text styling (like blue color and underline). If you want to remove both the link and the formatting, choose 'Remove Hyperlinks' from the same dropdown.

Solution 2

Disable AutoFormat for Future Inputs

Prevent Excel from automatically turning email addresses and URLs into clickable hyperlinks as you type.

Free Spreadsheet Editor

Effortlessly Manage and Remove Hyperlinks with WPS Office

WPS Spreadsheet offers a smooth and intuitive alternative for all your data management needs. You can easily remove unwanted hyperlinks, adjust formatting, and manage large datasets without missing features or frustrating glitches.

1. Open your Excel file: Launch WPS Spreadsheet and open your existing document containing the hyperlinks.
2. Select the data: Highlight the cells containing the links using your mouse or arrow keys.
3. Remove the links: Right-click the selected area and choose 'Remove Hyperlinks', or use the Clear tool located on the Home tab.

100% free and lightweight spreadsheet software.Highly compatible with Microsoft Excel (.xlsx, .xls) formats.Familiar user interface allows you to clear hyperlinks without relearning menus.Smoothly batch-remove links from massive datasets.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the 'Remove Hyperlink' option show up when I right-click in Excel?

This can happen if the worksheet is protected, if multiple ranges with mixed data types are selected, or due to a temporary UI glitch in Excel. Using the Home tab's Clear feature is a reliable workaround.

How can I remove hyperlinks from an entire worksheet at once?

Press Ctrl+A to select the entire worksheet. Then, go to the Home tab, click the 'Clear' dropdown in the Editing group, and select 'Clear Hyperlinks'.

How do I stop the mail client prompt from popping up when editing a cell?

Avoid clicking directly on the hyperlink text. Instead, click on an adjacent blank cell and use the arrow keys to navigate to the hyperlinked cell, or click and hold the mouse button on the cell for a second until the cursor changes to a cross.

Document & File Issues