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

Page 1 of 2 12 LastLast

  1. Posts : 17
    Win 7 home premium 64 bit
       #1

    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 Computer


  2. Posts : 17,545
    Windows 10 Pro x64 EN-GB
       #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





    Kari
      My Computer


  3. Posts : 17
    Win 7 home premium 64 bit
    Thread Starter
       #3

    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 Computer


  4. Posts : 17,545
    Windows 10 Pro x64 EN-GB
       #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 Computer


  5. Posts : 4,776
    Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
       #5

    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 Computer


  6. Posts : 17
    Win 7 home premium 64 bit
    Thread Starter
       #6

    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 Computer


  7. Posts : 17,545
    Windows 10 Pro x64 EN-GB
       #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
    Kari
      My Computer


  8. Posts : 17
    Win 7 home premium 64 bit
    Thread Starter
       #8

    No the remove hyperlink choice is still grayed out.
      My Computer


  9. Posts : 17,545
    Windows 10 Pro x64 EN-GB
       #9

    I have no more ideas. I'll keep looking, posting here if I stumble upon something.
      My Computer


  10. Posts : 6,458
    x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
       #10

    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 Computer


 
Page 1 of 2 12 LastLast

  Related Discussions
Our Sites
Site Links
About 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 23:31.
Find Us