How to Excel automatically turning email addresses into hyper...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to Excel automatically turning email addresses into hyperlinks. When I
enter (e-mail address removed), I want it to stay regular text, and not get turned into a
hyperlink.
 
Try this

In 2002/2003 you can turn it of

Tools > Options > Spelling
Press "AutoCorrect Options" Button
AutoFormat As You Type Tab
Remove Check from "Internet and network paths with hyperlinks"
OK
OK

In older versions you can do this :

Or after you have fill in a address and Enter to confirm you
can use Ctrl-Z to make it text.

Or start the cell with a '
Excel see it as text then
 
Better to precede with an apostrophe
'(e-mail address removed)
 
Hi
depending on your version goto 'Tools - autocorrection' and in the
middle tab disable this feature
 
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

Deactivate email hyperlinks in Excel 2007 3
Email Address 2
Excel 2003 how to stop emails from turning into hyperlinks? 2
Turn Off Hyperlinks? 2
Open specific hyperlink (accept) automatically in email with outlook 0
how can I turn off hyperlink when typing email addressesl? 6
Clicking on cell with email address opens Outlook Express 2
Using the @ symbol in a cell 4

Back
Top