Hyperlinks in excel

  • Thread starter Thread starter Daryl
  • Start date Start date
D

Daryl

How do I stop excel from automatically inserting a
hyperlink when I insert an email address in a cell?
 
Hi Daryl!

In Excel 2002 and 2003 you can turn this off:

Tools > AutoCorrect Options
"AutoFormat as you type" Tab
Remove check from "Internet and Network paths with hyperlinks"
OK

For earlier versions see various options at:

Dave McRitchie:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperLinks

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi JE!

I would have referred to your page in my reply but I got hit problems
when I tested the link earlier. Seems OK now.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Norman Harker said:
I would have referred to your page in my reply but I got hit problems
when I tested the link earlier. Seems OK now.
Click to expand...

I've rearranged a few pages, but I've left autoforwarding links to
the new locations. Please let me know if a link's not working.
Thanks!
 
Hi JE!

It was a mysterious response, which was whjy I mentioned it.

The link seems to keep attempting to open the page; I was getting the
"click" associated with a page opening. It happened several times over
a 5 minute period. Maybe you were working on it at the time. Later
when I went back to it there was no problem. Other links to other
websites were working normally.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Norman Harker said:
It was a mysterious response, which was whjy I mentioned it.

The link seems to keep attempting to open the page; I was getting the
"click" associated with a page opening. It happened several times over
a 5 minute period. Maybe you were working on it at the time. Later
when I went back to it there was no problem. Other links to other
websites were working normally.
Click to expand...

Thanks. I'll keep an eye on it. I'm assuming you were using IE6?
 
Hi JE!

No! I use NetCaptor. It allows me Captor Groups of tabbed browsers.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top