O
oceanmist
How do I stop an email address in a cell appearing as a hyperlink?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Umlas
put a leading apostrophe in front of it.
M
Michael
Hi oceanmist. You could also go to Tools-Auto Correct Options, select the
Autoformat as you type tab and uncheck Internet & network paths with
hyperlinks. HTH
Autoformat as you type tab and uncheck Internet & network paths with
hyperlinks. HTH
W
Why Von
Hi there Michael,
What if the text is already in the cell - and you want to activate it?
Without right clicking on each cell individually?
Thanks!
WHyvon
What if the text is already in the cell - and you want to activate it?
Without right clicking on each cell individually?
Thanks!
WHyvon
M
Michael
Hi Why Von. If you select the cell where you want the hyperlink, you can
then press f2 and then press enter and it will create the hyperlink. This
only works one cell at a time, but it goes pretty fast. HTH
then press f2 and then press enter and it will create the hyperlink. This
only works one cell at a time, but it goes pretty fast. HTH
W
Why Von
THANK YOU Michael!
I since found another similar option - just double click each cell. Tedious
but does the trick.
There was a response on the forum for a macros - but I'm not that advanced
of a user.
Whyvon
I since found another similar option - just double click each cell. Tedious
but does the trick.
There was a response on the forum for a macros - but I'm not that advanced
of a user.
Whyvon
M
Michael
Thanks for the tip Why Von. I'll add it to my list.