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

Microsoft Community Contributor Award Recipient

Windows 8.1 Pro with Media Center
 
 

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:
Name:  2014-01-23_02h19_51.png
Views: 21
Size:  39.9 KB
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:
Name:  2014-01-23_02h26_24.png
Views: 21
Size:  32.5 KB




Kari


My System SpecsSystem Spec
23 Jan 2014   #3

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

Microsoft Community Contributor Award Recipient

Windows 8.1 Pro with Media Center
 
 

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

Windows 7 Home Premium
 
 
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

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

Microsoft Community Contributor Award Recipient

Windows 8.1 Pro with Media Center
 
 

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
Kari


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

Microsoft Community Contributor Award Recipient

Windows 8.1 Pro with Media Center
 
 

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
Reply

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




Thread Tools



Similar help and support threads for2: Cant unformat email address hyperlink in Excel the way HELP says I can
Thread Forum
Solved Website email hyperlink trouble Browsers & Mail
Solved Use of hyperlink in email reply Browsers & Mail
Need interpretive hyperlink preferably in cell within Excel Microsoft Office
Can I save an Outlook e-mail trail and hyperlink to it from Excel? 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 01:22 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33