Microsoft Excel Question: Download Questions PDF
How can I prevent hyperlinks from appearing when I type an email address?
Answer:
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.
* 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.
Download MS Excel Interview Questions And Answers
PDF