How to Remove Hyperlinks for e-mail Addresses in a Worksheet (Excel 2010/2007)
If you have a cell or cells containing e-mail addresses, they are probably hyperlinks. This type of Hyperlink will create an e-mail message with addresses already in the “To” field when you click on the cell. If you need to work with these cells it can be problematic to accidentally create an e-mail message by clicking on the cell. You can turn off the “Hyperlink” function in the cell or cells. Most of the time a Hyperlink is automatically created when you type a complete e-mail address in a cell in Excel.