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
tomseeley

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
Kari

Microsoft Community Contributor Award Recipient

 

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:
-2014-01-23_02h33_17.png
By default Excel adds a "mailto" hyperlink to each email address:
Name:  2014-01-23_02h19_51.png
Views: 25
Size:  39.9 KB
You do not need to Click and hold the cell, simply select it and right click, select Remove Hyperlink:
-2014-01-23_02h23_39.png
The email address no longer has a hyperlink:
Name:  2014-01-23_02h26_24.png
Views: 25
Size:  32.5 KB




Kari


My System SpecsSystem Spec
23 Jan 2014   #3
tomseeley

Win 7 home premium 64 bit
 
 

Kari,

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
Kari

Microsoft Community Contributor Award Recipient

 

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
Callender

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

Hi,

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
tomseeley

Win 7 home premium 64 bit
 
 

Kari,

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!


Arrrggghhhhhhhhhhhhhh

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.

Tom
My System SpecsSystem Spec
23 Jan 2014   #7
Kari

Microsoft Community Contributor Award Recipient

 

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.
-2014-01-24_02h35_37.png
Kari


My System SpecsSystem Spec
23 Jan 2014   #8
tomseeley

Win 7 home premium 64 bit
 
 

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

Microsoft Community Contributor Award Recipient

 

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

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
Reply

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




Thread Tools




Similar help and support threads
Thread Forum
Chrome crashes when I try to open a hyperlink from My Email client
Ok, when I open my email client, whatever it may be I had an email from someone that had a HTTP link to a forum for me. When I click on this link, Google Chrome, my default browser tries to open the link, but all that happens is my extensions in Chrome all report crashing in the bottom right corner...
Browsers & Mail
Website email hyperlink trouble
Greets from Japan ...New computer with Windows 7 and latest IE version . When I click on a email contact hyperlink on websites I am not able to access automatically via Windows Live Mail which my old HP with the same 7 and IE has no problem with . A message pops up in Japanese , something about the...
Browsers & Mail
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
Unable send clickable hyperlink from IE9 using default email
I can send links going to : "Page" > " Send link by email", but they are set in plain text and cannot be clicked by the receivor of the email to bring up the desred page. :( If I copy and paste the link on a new Windows Live Mail message it works just fine - the link is clickable. :confused: ...
Browsers & Mail
Mozilla ignores profile when opened via email/web hyperlink
When I open Mozilla via local icons, it will read and load a specific profile. This allows me to use 3.6.13 (..\firefox.exe" -p "FF_3_6_13" -no-remote) and 4.0b9pre (..\firefox.exe" -p "Minefield64" -no-remote) without one interfering with the other. (4.0b9pre is set as default). When the...
Browsers & Mail


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 02:58.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App