how can I turn off hyperlink when typing email addressesl?

  • Thread starter Thread starter Leigh
  • Start date Start date
L

Leigh

In Excel, when I type an email address it puts it an hyperlink, and I can't
figure out to turn that off or just treat it like text. When you need to
edit, it is a challenge.

Any suggestions?
 
You can click and hold to select the cell instead of following the link.

If you are using Excel 2003 then got to
Tools->AutoCorrect Options and select the second tab 'Autoformat as you type'
Clear the checkbox 'Replace as you type....'
 
You can click and hold to select the cell instead of following the link.

If you are using Excel 2003 then got to
Tools->AutoCorrect Options and select the second tab 'Autoformat as you type'
Clear the checkbox 'Replace as you type....'
 
I've never learned how to turn to turn it off, but for me, as I type and
press ENTER and the hyperlink appears, I've discovered immediately pressing
CTRL-Z and the hyperlink is removed but the text is still there.
 
I've never learned how to turn to turn it off, but for me, as I type and
press ENTER and the hyperlink appears, I've discovered immediately pressing
CTRL-Z and the hyperlink is removed but the text is still there.
 

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
Excel 2003 how to stop emails from turning into hyperlinks? 2
Turn Off Hyperlinks? 2
Email Address 2
Open specific hyperlink (accept) automatically in email with outlook 0
Change hyperlink name to url 1
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! 1
Will not auto open .jpg 1

Back
Top