excel and email addresses...help

Factual Questions
1

in the excel data base i am keeping for an organization email addresses are part of the information to be listed. every time i type in an email address in comes up as a shortcut, in blue and a line underneath.

can not figure out how to stop this from happening. i want the email address to be just plain type. i tried the “show as typed” format and it still came up as a shortcut.

is there anyway to stop this? microsoft word does the same damn thing.

2

In excel: It might be the ‘autoformat as you type’, under tools>autocorrection. Try unchecking the box & see whappens.

3

In Excel, right click the email address, select hyperlink and deactivate hyperlink. I don’t know that there is a way to do it for all email addresses.

4

If the above does not work, you will have to change each address manually – right click on the address>Hyperlink>Remove Hyperlink.

This works in both Word and Excel.