Forum Discussion
Help! Hyperlink style went missing (cell styles)
Hi, I hope someone can help. I have been working in some spreadsheets and have been successfully converting columns of email addresses to hyperlinks using the cell style "hyperlink." I just opened a...
Hi, FSSimon
Ctrl+K will open up hyperlink in the current cell. There you can map to where you want it to go - and upon saving you will get the traditional hyperlink format you were looking for.
It doesn't answer your question of what happened - but it is a band-aid for the time being.
Fortijo Thanks so much, but I have a column populated with thousands of email addresses. Would I have to do that in every one, or can I select all?
FSSimonYou could use the HYPERLINK function in another column to generate links quickly. The formula if your first email address was in C3 would look like this;
=HYPERLINK("Mailto:"&C3,C3)
