Microsoft Excel Interview Question:

How can I prevent hyperlinks from appearing when I type an email address?

Submitted by: Administrator

To turn that option off in Excel 2002 and Excel 2003:

* Choose Tools | AutoCorrect Options
* Select the AutoFormat as you type tab
* Remove the check mark from Internet and network paths with hyperlinks
* Click OK

To undo the hyperlink creation in all versions:

* Type the email address and press Enter
* Immediately, press Ctrl+Z. This is a shortcut for Undo, and will convert the hyperlink back to text.
Submitted by: Administrator