Don't want link

  • Thread starter Thread starter eintpc5146
  • Start date Start date
E

eintpc5146

I have a list of e-mail addresses on a spreadsheet. They automatically
convert to hyperlinks. I don't want these as links- simply a list of
addresses. How do I prevent this from happening?

Thanks!
ei
 
Just select and copy the data and do right click>>Paste Special>>Values>>Ok.

Remember to Click Yes, if this post helps!
 
I had already tried that and for some reason it is not working. Any (other)
suggestions?
Thanks!
 
What you can do is after you have typed the email address right click on the
cell and select Remove Hyperlink option.

But u need to do it manually for all the cells one by one, u can't select
all and remove the hyperlink in one go.

Hope this is useful for you.
 
Back
Top