# excel and email addresses...help

**URL:** <https://boards.straightdope.com/t/excel-and-email-addresses-help/163730>\
**Category:** Factual Questions\
**Created:** [March 24, 2003, 6:22am UTC](https://boards.straightdope.com/t/excel-and-email-addresses-help/163730 "2003-03-24T06:22:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![biker](https://avatars.discourse-cdn.com/v4/letter/b/ce7236/32.png) [@biker](https://boards.straightdope.com/u/biker)\
**Post date:** [March 24, 2003, 6:22am UTC](https://boards.straightdope.com/t/excel-and-email-addresses-help/163730/1 "2003-03-24T06:22:31Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Swirdle](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@Swirdle](https://boards.straightdope.com/u/Swirdle)\
**Post date:** [March 24, 2003, 7:00am UTC](https://boards.straightdope.com/t/excel-and-email-addresses-help/163730/2 "2003-03-24T07:00:17Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Richard\_Pearse](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/richard_pearse/32/13144_2.png) [@Richard\_Pearse](https://boards.straightdope.com/u/Richard_Pearse)\
**Post date:** [March 24, 2003, 7:05am UTC](https://boards.straightdope.com/t/excel-and-email-addresses-help/163730/3 "2003-03-24T07:05:24Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![peri](https://avatars.discourse-cdn.com/v4/letter/p/67e7ee/32.png) [@peri](https://boards.straightdope.com/u/peri)\
**Post date:** [March 24, 2003, 7:09am UTC](https://boards.straightdope.com/t/excel-and-email-addresses-help/163730/4 "2003-03-24T07:09:31Z")

</div>

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.