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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Activating hyperlinks 3
Activate email hyperlinks in imported data 1
Open specific hyperlink (accept) automatically in email with outlook 0
Maintaining hyperlinks when I move Excel files to another location 1
Activate email column to hyperlinks 2
Hyperlinks changed by Excel again! 5
activate mutiple links 4
Moving Hyperlinks 2

Back
Top