Activce Hyperlinks
Hi! Expert
I have a 5000 E-Mail IDs in on column. Now want to Active these Email Ids. How Can i Active These Email ID With just one Click or i have to press F2 Thanks In Advance Hardeep kanwar |
Activce Hyperlinks
|
Activce Hyperlinks
Thanks Gary''s
It Works fine for me but is there any way without using Formulas. I mean to say in the Simple way that we use for pressing F2 or Double Click and then Enter Because with this function i have to Add another column in my sheet Thanks Hardeep kanwar "Gary''s Student" wrote: Suppose column A has material like: then in B1, enter: =HYPERLINK("mailto:" & A1) and copy down. This will create nice, "clickable", hyperlinks. -- Gary''s Student - gsnu200824 "Hardeep_kanwar" wrote: Hi! Expert I have a 5000 E-Mail IDs in on column. Now want to Active these Email Ids. How Can i Active These Email ID With just one Click or i have to press F2 Thanks In Advance Hardeep kanwar |
All times are GMT +1. The time now is 08:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com