View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mark Mark is offline
external usenet poster
 
Posts: 989
Default E-Mail Issue in Excel

"Susan" wrote:

An Excel spreadsheet was sent to me by a superior in my office. There are
E-Mail addresses in one column. There are multiple columns that when you try
to click on and/or enter data into, a new mail message opens up in Outlook to
one of those email addresses. I can not figure out how to get this to stop
and neither can my superior.


Try this:
1) right click on the cell with the email
2) select "remove hyperlink"
3) click on the "format painter icon"
4) select the colums with the email addresses. This should remove the
hyperlinks.