ExcelBanter - Hyperlinks in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hyperlinks in excel (https://www.excelbanter.com/excel-discussion-misc-queries/174439-hyperlinks-excel.html)

Kristen

Hyperlinks in excel

I am wanting to change a whole column of websites into hyperlinks without
having to do each individually. Is that possible?

Gary''s Student

Hyperlinks in excel

Say you websites are in column A from A1 thru A100. In B1 enter:

=hyperlink(A1) and copy down
--
Gary''s Student - gsnu200766

"Kristen" wrote:

I am wanting to change a whole column of websites into hyperlinks without
having to do each individually. Is that possible?

All times are GMT +1. The time now is 03:18 PM.