Stop Excel from Opening Email When Selecting an Address
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.
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.
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.
Click the column header or drag across the cells containing the email addresses you want to change.
Right-click the selected cells to display the available formatting and hyperlink commands.
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.
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. Open the workbook: Launch WPS Office, open WPS Spreadsheet, and load the workbook containing the email addresses.
- 2. Select the affected cells: Select the email-address column or the specific cells whose clickable behavior you want to remove.
- 3. Open the context menu: Right-click the selected cells to view the available cell and hyperlink commands.
- 4. Choose Remove Hyperlinks: Click Remove Hyperlinks. WPS Spreadsheet keeps the addresses as text and prevents them from opening an email message when clicked.

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.




