Question About Excel Email Cell Format

Dear Computer Lady,

I am baffled by a cell format issue in Excel (ver. 2003).

For some unknown reason, when I enter a person’s email address in a cell, Excel automatically formats the entry with a “Mailto” format or tag. So when I click on the cell, my email client opens up with a blank email message.

How do I change this to a plain vanilla data entry?

Jack

Dear Jack,

Just right click on either the individual cell with the email address, or highlight and right click on the entire column with email addresses.

In the context menu that appears, you will see “Remove Hyperlinks”.

Just click on “Remove Hyperlinks” to convert the email addresses back to plain text.

Elizabeth

It’s Your Turn: What do you think?
…. Share your experience in the comments box below.

Elizabeth Boston is a Web designer, Social Media Consultant and managing editor of, “Ask The Computer Lady”.
Connect with

Previous Post

How Do I Uninstall Windows Live Mail

Next Post

How To Change Default Word Template