helix1
Level 1 (4 points)
iWork

Q: stop email addresses in spreadsheet table from launching mail

I'm compiling data in a Numbers spreadsheet and a lot of cells in the table have email addresses in them.

Each time I tap on the cell with an email address, it jumps to my Mail App and launches a new mail with the email address. That is so irritating cos I need to tap on so many address in the table and I DO NOT WANT my Mail App to launch. How can I stop this craziness? Please HELP!

MacBook Pro with Retina display, OS X El Capitan (10.11.6), Numbers version 3.6.2 (2577)

Posted on Aug 20, 2016 9:24 AM

by Yellowbox,Solvedanswer
Yellowbox Yellowbox
Level 6 (10,550 points)
Mac OS X
A:

Hi helix,

Screen Shot 2016-08-21 at 2.32.33 AM.png

Drag Column A wider (or Format Panel > Table > Column)

Screen Shot 2016-08-21 at 2.39.21 AM.png

Click on the white space to the right of the link to select that cell without activating the link

Screen Shot 2016-08-21 at 2.48.03 AM.png

Now edit

Screen Shot 2016-08-21 at 2.54.59 AM.png

Tested on a MacBook Pro with Numbers 3.6.2 under Mac OS X El Capitan 10.11.5

 

Regards,

Ian.

Posted on Aug 20, 2016 10:08 AM

Close
helix1

Q: stop email addresses in spreadsheet table from launching mail

  • All replies
  • Helpful answers

  • by Yellowbox,Solvedanswer

    Yellowbox Yellowbox Aug 20, 2016 10:08 AM in response to helix1
    Level 6 (10,550 points)
    Mac OS X
    Aug 20, 2016 10:08 AM in response to helix1

    Hi helix,

    Screen Shot 2016-08-21 at 2.32.33 AM.png

    Drag Column A wider (or Format Panel > Table > Column)

    Screen Shot 2016-08-21 at 2.39.21 AM.png

    Click on the white space to the right of the link to select that cell without activating the link

    Screen Shot 2016-08-21 at 2.48.03 AM.png

    Now edit

    Screen Shot 2016-08-21 at 2.54.59 AM.png

    Tested on a MacBook Pro with Numbers 3.6.2 under Mac OS X El Capitan 10.11.5

     

    Regards,

    Ian.

  • by helix1,Helpful

    helix1 helix1 Aug 20, 2016 10:07 AM in response to Yellowbox
    Level 1 (4 points)
    iWork
    Aug 20, 2016 10:07 AM in response to Yellowbox

    Of Course! It's supposed to be that simple! Lol..

    Thanks so much Ian!!    

  • by Yellowbox,

    Yellowbox Yellowbox Aug 20, 2016 10:12 AM in response to helix1
    Level 6 (10,550 points)
    Mac OS X
    Aug 20, 2016 10:12 AM in response to helix1

    Hi helix,

    Thanks for the green tick and your feedback.

    Keep posting in Numbers for Mac .

    Regards,

    Ian.

  • by think.different,

    think.different think.different Aug 20, 2016 10:14 AM in response to helix1
    Level 4 (1,024 points)
    Desktops
    Aug 20, 2016 10:14 AM in response to helix1

    If you just want to edit the email addresses then widen the column so you can double click in the white space of the cell, this causes you to enter text edit mode.

     

    To stop new data turning into smart links, go Edit > Substitutions > Smart Links (off)

     

    I think you can only remove the hyperlink one at time (I can only test with 3.6), highlight link, right click, edit link, remove.

     

    In older versions, with the separate inspector palette, you could just select all email addresses and then go to the Hyperlink tab of the Inspector and uncheck "enable as hyperlink.

  • by helix1,

    helix1 helix1 Aug 20, 2016 10:24 AM in response to think.different
    Level 1 (4 points)
    iWork
    Aug 20, 2016 10:24 AM in response to think.different

    hi think.different,

     

    thanks for the response. I learnt a few more things with your post.

    however, just fyi turning off smart links via substitutions didn't work for me. not sure why though.

     

    nonetheless, pulling the column wider has helped a lot! thanks too anyways.

  • by think.different,

    think.different think.different Aug 20, 2016 10:28 AM in response to helix1
    Level 4 (1,024 points)
    Desktops
    Aug 20, 2016 10:28 AM in response to helix1

    turning off smart links only seems to work for new emails added not de-hyperlinking existing ones. If it is turned off and you add a new email address it stays as plain text.

  • by helix1,

    helix1 helix1 Aug 20, 2016 10:31 AM in response to think.different
    Level 1 (4 points)
    iWork
    Aug 20, 2016 10:31 AM in response to think.different

    I see now. It works great too! Thanks much!