Forum Discussion
entering email addresses into excel
When I enter an email address the format changes so that it is a link, I am having issues getting this to stop as I want the email address in the list in excel to remain white and the same as all the...
You can right click email addresses and hit "Remove hyperlink" this will turn in to text again. Or, you can keep the link there and use the format painter tool to copy a normal cell and drag it over your list of emails, this will make your email addresses not look like hyperlinks.
- This does not work
- The format painting or the removal of hyperlinks? I tested both, you have to copy the correct formatting first then paint onto the hyperlink. Or copy/paste format works as well.
- I don't know what you mean by "Format Painting"?
