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?
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.
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 Elizabeth on Google+