How can I make multiple hyperlinks active at one time?
 

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?

How can I make multiple hyperlinks active at one time?
 

What do you mean by making acitve all at one time?



"lboti" wrote:

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?

How can I make multiple hyperlinks active at one time?
 

I would use a helper column with a worksheet function:

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

If the email address were in A1.

lboti wrote:

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?

--

Dave Peterson