email addresses in cells

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

Guest

If I enter an email address into a cell, Excel underlines it and then treats
it as a live address. This makes it impossible to edit. The only solution I
have found is to use Paste Special, but even then the pasted version becomes
live again as soon as you have finished editing it.

Does anyone know a way of switching this maddening feature off - either
temporarily or permanently?

Tony
 
In XL 2002 and 2003 you can turn this off through Tools>AutoCorrect
Options>AutoFormat as you type.

Uncheck the box you find there.


Gord Dibben Excel MVP
 
Hi

tools / autocorrect options / autoformat as you type - UNTICK internet and
network paths with hyperlinks

be warned, this may affect other programs like Word.

Alternatively, as soon as Excel changes it to a hyperlink use ctrl & z to
"undo" the change (or the undo icon on the toolbar)
 
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

Clicking on cell with email address opens Outlook Express 2
Email Address 2
Activate email hyperlinks in imported data 1
How to extract email addresses from 1 worksheet to another workbook 11
Cells containing email address 2
Paste Special Formula Multiply feature doesn't work anymore 2
Compiling email addresses from individual cells 2
Autocomplete for email addresses in a cell 1

Back
Top