I didn't find this topic in a search of this forum, hopefully someone can help.

I have a column in a spreadsheet that is email addresses. Excel does not automatically make them hyperlinks, but I would like them to be. I want to be able to click on an email and have my email open up.

I can make the hyperlinks individually, but I can't do it for an entire column at once.

Thanks!