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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert a hyperlink as the text in the cell? 2
Open specific hyperlink (accept) automatically in email with outlook 0
Hyperlinks in Excel 1
Activating hyperlinks 3
How do I disable the hyperlink for e-mail addresses in Excel? 1
Deactivate email hyperlinks in Excel 2007 3
Insert hyperlink ini Excel 1
Mailto hyperlinks 2

Back
Top