How can I stop excel from automatically making hyperlinks

M

MAB5025

I am using Excel 2003. Whenever I enter an email address in a cell, it turnes
into a hyperlink as soon as I click enter. How can I stop excel from doing
that. It is making it very difficult to work with excel. It started to do
this even though I have been using excel for years.
Thank you for you help.
Marty
 
D

Dave Peterson

You can turn off this autocorrection feature:

Tools|autocorrect options|autoformat as you type tab|uncheck that top option.
 
B

Biff

Hi!

In Excel 2002:

Goto Tools>AutoCorrect options>Auto format as you type tab

Uncheck Internet and network paths with hyperlinks

Ok out

Biff
 
M

MAB5025

Hello Dave Peterson,
Thank you very much for your help in solving my problem with excel. Your
solution was so easy to do, I'm sorry I didn't know about it. From now on I
will, thanks to you. Marty
 
M

MAB5025

Hello Biff,
Thank you very much for your help in solving my problem with excel. I
appreciate your speedy response, since I had trouble moving forward with my
work.
Marty
 
B

Biff

You're welcome. Thanks for the feedback!

Biff

MAB5025 said:
Hello Biff,
Thank you very much for your help in solving my problem with excel. I
appreciate your speedy response, since I had trouble moving forward with
my
work.
Marty
Click to expand...
 

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

Merging from an Excel file with graphics 1
Paste to excel from word - auto format problem 1
Making "Change Highlighting" feature darker 1
Excel suddenly crippled by Just-In-Time Debugging 2
Hyperlinks changed by Excel again! 5
How do I set focus (and select text) on a text box on a modeless userform? 0
Hyperlinks for .rm files stopped working 1
Updates for excel 2002/3 0

Top