How can I make multiple hyperlinks active at one time?

  • Thread starter Thread starter lboti
  • Start date Start date
L

lboti

I have a large excel spreadsheet and I need to make a column of emails all
have hyperlinks. Can I make them active all at one time or do I need to
activate them one by one?
 
I would use a helper column with a worksheet function:

=hyperlink("mailto:" & a1, "Click Me")

If the email address were in A1.
 
Back
Top