Hyperlinks

[robert.behney]

Can excel for Mac be set to a default where email addresses are
entered as plain text, and not automatically converted to hyperlinks?

 

[CyberTaz]

Unfortunately, no - at least not as far as any kind of Preference setting.
The simplest workaround is to type an apostrophe first followed by the email
address. At least I'm pretty sure this works in Mac XL just as it does in
the PC version. I'd test it to see if my memory serves me correctly, but
don't have access to a Mac at the moment.

It seems like there is a macro available to either turn it off
programatically or convert all hyperlinks to plain text, but I'll leave it
to one of the more knowledgeable coders to handle that possibility

 

[JE McGimpsey]

Can excel for Mac be set to a default where email addresses are
entered as plain text, and not automatically converted to hyperlinks?

See

http://www.mcgimpsey.com/excel/nohyperlinks.html

and

http://www.mcgimpsey.com/excel/nohyperlinks2.html

 

[CyberTaz]

By Golly, John, I even went to your site searching for those d*mned things &
looked right past them. You need to use a larger font size

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[little_creature]

By Golly, John, I even went to your site searching for those d*mned things &
looked right past them. You need to use a larger font size

Regards |:>)
Bob Jones
[MVP] Office:Mac

By Golly, John, I even went to your site searching for those d*mned things &
looked right past them. You need to use a larger font size

As I'm in a bit peckish (or what is the right word when you can find
different meaning in every word which is said by someone) mood, I
cannot help:
What about glasses or enlarging text in your browser

Or another approach:
let excel do the hyperlinks, then select the whole column where you
have email address and do APPLE+X, navigate to neighbor column and do
EDIT>PASTE>SPECIAL>VALUES. You need to paste it to neighbor column
(which you can insert prior to APPLE+X and than remove the original
after pasting) otherwise the links will not be removed.

 

[CyberTaz]

Hi l_c - Always a pleasure to hear from from you! I don't know if it's
exactly what you meant, but the definition I found is:

Encarta® World English Dictionary © 1999 Microsoft Corporation. All rights
reserved. Developed for Microsoft by Bloomsbury Publishing Plc.

peck·ish adj (informal)
1. somewhat irritable or in a bad mood
2. U.K. slightly hungry

Unfortunately, when you Cut in Mac Excel, Paste Special isn't available...
Can't remember if PC Excel works the same or not. Further limit, I'm afraid,
is that even if you Copy>Paste Special [any option] to the same cells they
still get pasted back as hyperlinks. They'd have to be pasted as values to a
different column, then the original column deleted. Regrettably, any
workaround is more trouble than it _should_ be - all they need is a simple
checkbox to enable/disable active hyperlinks Maybe next version???

BTW - I've got the glasses & just don't like to play around with browser
settings as much as I like to tease John;-) His web site, however, is
actually one of the best I've seen!

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Harvey Waxman]

They'd have to be pasted as values to a
different column, then the original column deleted. Regrettably, any
workaround is more trouble than it _should_ be -

I hit cmd-z after the entry which will remove the link and leave the text. For
several at a time I have a macro icon in the menu bar to remove links.

FWIW

 

[little_creature]

Hi l_c - Always a pleasure to hear from from you! I don't know if it's
exactly what you meant, but the definition I found is:

Encarta® World English Dictionary © 1999 Microsoft Corporation. All rights
reserved. Developed for Microsoft by Bloomsbury Publishing Plc.

peck·ish adj (informal)
1. somewhat irritable or in a bad mood
2. U.K. slightly hungry

Hello CyberTaz,
that's not any of the meaning my dictionary has said... Anyway you
give me the answer in: I like to tease John;-).

Unfortunately, when you Cut in Mac Excel, Paste Special isn't available...
Can't remember if PC Excel works the same or not. Further limit, I'm afraid,
is that even if you Copy>Paste Special [any option] to the same cells they
still get pasted back as hyperlinks.

That's why I said: navigate to neighbor column and do
EDIT>PASTE>SPECIAL>VALUES.
Someone previosly explain me that in here that the property is stored
in the cell - so if you paste special into same colum it will not work
- you need to go to neighbour. But I fully agree with you - one simple
checkbox would be fine.

BTW - I've got the glasses & just don't like to play around with browser
settings as much as I like to tease John;-) His web site, however, is
actually one of the best I've seen!

What about mine? OK, now I have done a note in my notebook now,
saying:
CyberTaz like to tease John with big black spot as he do not like my
web pages And now the whole World knows, what you are like ;-).


I will not tease CyberTaz. I will not tease CyberTaz. I will not tease
CyberTaz. I will not tease CyberTaz. I will not tease CyberTaz. I will
not tease CyberTaz. I will not tease CyberTaz. I will not tease
CyberTaz. ....

I know how hard is to make webpage working or even looking same in all
browser. I did a CSS for highlighting commands which looked OK in FF
but was HUGE in IE. From this point IE is nightmare.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[CyberTaz]

<snip>

What about mine?

<snip>

Haven't had the pleasure of seeing yours, but I'd love to take a peek;~} If
you don't want to post the URL send it to me in an email:

Cybertaz at comcast (dot goes here) net

Regards |:>)
Bob Jones
[MVP] Office:Mac