Formatting Issues

Stop Excel from Opening Email When Selecting an Address

Khadija KhanKhadija Khan Nov 12, 2026 868 views

Question details

The user needs to prevent email addresses in a spreadsheet from opening a new email message when selected.

Product
Microsoft Excel
Device & OS
not provided
Scenario
An Excel worksheet contains email addresses that have been automatically converted into clickable hyperlinks.
Observed behavior
Selecting an email address opens or attempts to open a new email message instead of leaving the address as plain text.
Before you start

Identify the column or cells containing the email addresses and exit cell-edit mode before applying the formatting change. Select only the affected range if other hyperlinks in the worksheet should remain active.

Solution 1Recommended

Remove hyperlinks from the email-address cells

Use this option when email addresses should remain visible as text and should no longer open a new message when clicked.

1
Select the email addresses

Click the column header or drag across the cells containing the email addresses you want to change.

2
Open the cell context menu

Right-click the selected cells to display the available formatting and hyperlink commands.

3
Remove the hyperlinks

Choose Remove Hyperlinks from the context menu. The email addresses will remain in the cells as plain text and will no longer open an email message when selected.

Hyperlink behavior removed: Removing the hyperlinks does not delete the email addresses; it only removes their clickable link formatting.

Remove Email Hyperlinks in WPS Spreadsheet

WPS Spreadsheet lets you select an email-address range and use the context menu to remove hyperlinks, keeping the addresses as plain text without opening an email message.

  1. 1. Open the workbook: Launch WPS Office, open WPS Spreadsheet, and load the workbook containing the email addresses.
  2. 2. Select the affected cells: Select the email-address column or the specific cells whose clickable behavior you want to remove.
  3. 3. Open the context menu: Right-click the selected cells to view the available cell and hyperlink commands.
  4. 4. Choose Remove Hyperlinks: Click Remove Hyperlinks. WPS Spreadsheet keeps the addresses as text and prevents them from opening an email message when clicked.
Stop email addresses from opening a new message when selectedKeep the original email-address text in the worksheetUse a familiar spreadsheet interface with quick right-click formatting toolsOpen and edit Microsoft Excel .xlsx and .xls files with compatible formattingMake hyperlink cleanup easy in a lightweight spreadsheet editor
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel open an email message when I select an address?

Excel automatically recognizes text containing an email address and formats it as a mailto hyperlink. Selecting the linked cell can open the default email application.

How can I remove email hyperlinks from an entire Excel column?

Select the column or the relevant range, right-click the selection, and choose Remove Hyperlinks. The email addresses will remain while their clickable links are removed.

Will removing a hyperlink delete the email address?

No. The Remove Hyperlinks command removes only the link behavior and formatting; the email-address text remains in the cell.

Can I remove email hyperlinks in WPS Spreadsheet?

Yes. Open the workbook in WPS Spreadsheet, select the email-address cells, right-click the selection, and choose Remove Hyperlinks.