CODEWITHSUNDEEP
excel
Jennifer Zou
Jennifer Zou

Reputation: 197

Excel - How to automatically convert Text URL to active hyperlinks?

I have an Excel file which needs to be sent to my colleagues. However, there is a column "link" which includes the text URL, the URL only can be activated when I double click this cell. How can I automatically activate these text URLs so my colleagues don't need to double click on each cell? enter image description here

Thanks, Jennifer.

Upvotes: 5

Views: 22431

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

With inactive links in column A, in B2 (or some other column) enter:

=HYPERLINK(A2,A2)

and copy downward.

This costs you an extra column, but it minimizes the need for "special handling". An alternative approach might be to activate all the cell in the column with a small SendKeys macro.

Upvotes: 6

Related Questions