Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Cant unformat email address hyperlink in Excel the way HELP says I can

22 Jan 2014   #1

Win 7 home premium 64 bit
Cant unformat email address hyperlink in Excel the way HELP says I can

I'm about to put my foot through my computer! I hate it when I go to a help screen, I understand the message I find, and the program won't behave the way the help screen says it will!

I'm running Excel 2010 which I'm comfortable with without being an expert. I've inherited a membership list file that has a column containing members' email addresses. Some of the members' email addresses in that column are formatted as a hyperlink format, so that they automatically launch my email program when I click on those entries. Some of the addresses in the same column are in a format that LOOKS like the typical hyperlink format (blue underlined etc) but which are actually simply text format. When I click on those addresses in that column, I do not launch my email program. That's how I want all the entries in that column to behave!

I do NOT want ANY of them to automatically launch my email program!!!!!!!!!!!!

I went to the Office online help and found a message for how to delete a hyperlink. It says I click and hold the cell containing the entry I do NOT want to be a hyperlink that will automatically launch my email, and the cursor will change from the pointer to a cross. OK. Been there done that. It then says Right click and in the context-sensitive drop down menu that appears, click "remove hyperlink". I can understand that, too.

But guess what! When I do that, the "remove hyperlink" entry in the drop down menu is grayed out!

What am I doing wrong?

How am I supposed to do what I want to when the program doesn't behave the way the help message says it does!

My System SpecsSystem Spec
22 Jan 2014   #2


Whatever I try, I cannot reproduce your issue. Removing "mailto" hyperlinks works exactly as it should work both on Excel 2010 and 2013. Only way to not be able to select Remove Hyperlink in context menu is if the cell is protected, editing disabled, in which case the context menu does not even have the Remove Hyperlink item as this screenshot shows:
Cant unformat email address hyperlink in Excel the way HELP says I can-2014-01-23_02h33_17.png
By default Excel adds a "mailto" hyperlink to each email address:
Cant unformat email address hyperlink in Excel the way HELP says I can-2014-01-23_02h19_51.png
You do not need to Click and hold the cell, simply select it and right click, select Remove Hyperlink:
Cant unformat email address hyperlink in Excel the way HELP says I can-2014-01-23_02h23_39.png
The email address no longer has a hyperlink:
Cant unformat email address hyperlink in Excel the way HELP says I can-2014-01-23_02h26_24.png


My System SpecsSystem Spec
23 Jan 2014   #3

Win 7 home premium 64 bit


I wish I could duplicate YOUR environment! I'm not trying to argue or pick a fight, but I'll stand by what I said. When I do exactly what you said to do, the remove hyperlink is grayed out! I guess I'll have to live with it, even though it means I can't ever click on any of these offending cells or it will launch my email program in the middle of what else I'm trying to do without being interrupted by something I don't want!

Thx for trying.
My System SpecsSystem Spec

23 Jan 2014   #4


Please test this:

Type an email address in an empty cell on a new workbook created just for this test, hit Enter. Select the cell, right click. Is the Remove Hyperlink item on context menu still grayed out?
My System SpecsSystem Spec
23 Jan 2014   #5

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
Suggest - Try ASAP Utilities add on


Sorry to butt in but if you can't get Excel working the way it should be working there's a pretty good add in available for free with tons of utilities.

It can:

Remove all hyperlinks

I use it on my machine at work mainly for text manipulation and deduplication of records but it has so many other features too.
Hierarchical list of all ASAP Utilities (sub)menu items

This add on only works with MS Excel 32bit versions which is typically installed even on 64bit machines. Basically if you see MS Office listed in your Program Files x86 folder then you've got 32bit MS Office installed.
Download ASAP Utilities
My System SpecsSystem Spec
23 Jan 2014   #6

Win 7 home premium 64 bit


First of all, let me say thank you for continuing to stay involved in this puzzle. For me, it's a PITA but it's not a showstopper! I'm curious but I'm not going to be obsessed about it much longer (I hope; knowing me, I might, though!).

Here's what I can report:

1. I copied a link from cell G7 in the orig file, which appears with a "mailto..." message as illustrated above, so I know it's a hyperlink in the orig file. I pasted this single sell into cell A1 in a new, blank workbook. At this point, it is still a hyperlink.

2. In the new workbook, I right click on cell A1 and the "remove hyperlink" choice is available.

3. I click "remove hyperlink" and cell A1 reverts to a normal cell. It is no longer a hyperlink. The "mailto.." thing is no longer present.

4. I then copy this modified not-a-hyperlink cell A1 back into cell G7 in the orig file. Cell G7 is still a hyperlink! The remove hyperlink choice is no longer available when I right click on cell G7!


Like I said, I can work around it, so feel free to ignore me from this point forward, unless it's got you puzzled enough too that you want to keep working on it!

Thanks again.

My System SpecsSystem Spec
23 Jan 2014   #7


Check the Autoformat as you type option, if automatic links is enabled, disable it, close and reopen Excel and see if the Remove Hyperlinks is now visible.
Cant unformat email address hyperlink in Excel the way HELP says I can-2014-01-24_02h35_37.png

My System SpecsSystem Spec
23 Jan 2014   #8

Win 7 home premium 64 bit

No the remove hyperlink choice is still grayed out.
My System SpecsSystem Spec
23 Jan 2014   #9


I have no more ideas. I'll keep looking, posting here if I stumble upon something.
My System SpecsSystem Spec
23 Jan 2014   #10

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem

I haven't used Excel in a while, please excuse the rust.

Try this:
Save the spreadsheet as a .csv file (tab delimited)
>> If there is more than one sheet in the Excel file, just try one.
>> if this works, you can process any other sheets in the Excel file

Open the .csv file as a new Excel speadsheet (only tab delimited in the import dialog)
>> You should be able to double click the .csv file and it will open an import dialog in Excel

Are the eMail addresses still mailto:'s
Can you remove hyperlink from them in this version of the Excel file?
My System SpecsSystem Spec

 Cant unformat email address hyperlink in Excel the way HELP says I can

Thread Tools

Similar help and support threads
Thread Forum
Excel has an Automatic Hyperlink location changer APP DATA ROAMING
Microsoft Excel and Windows re-arranged links to Roaming App Data I have made this spreadsheet that is supposed to work on more than one Windows 7 -10 computers. The spreadsheet uses photos and they are embedded into the cells and they have a hyperlink to their location They live C:\MT FILES See...
Microsoft Office
Hi Guys, I havecreated an Excel spreadsheet. I have hyperlinked various cells to other foldersbut I’m getting a warning (See Below) appearing when I click inside the cellwhich has been hyperlinked, the warning says that the folder I am linking to isan “unsafe location do you want to continue...
Microsoft Office
Excel creating hyperlink to a website
I have a spreadsheet in Excel 2007 to which I want to create a hyperlink to an external website, which contains a special calculator, I will need to make reference. The link has been placed in a cell of the spreadsheet and would appear activated, as blue, but clicking on cell does not open the...
Microsoft Office
Use of hyperlink in email reply
Using Outlook V10, adding hyperlink to an original message works fine. When I do a reply, inserting a hyperlink sometimes works. And for some message replies, the formatting and hperlink icons are not available. Is there an explanation for this?
Browsers & Mail
Can I save an Outlook e-mail trail and hyperlink to it from Excel?
Hi guys I have an Excel spreadsheet that tracks document reviews. One form of evidence that a document has been reviewed is an e-mail from the reviewer (eg, "I've reviewed it and told John to make corrections as per the attached"). Aside from printing the mail to a pdf and saving it somewhere...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 13:05.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App