Forum Discussion
Convert Column Of URLs To Hyperlinks
For Mac users the simplest solution for converting a list of text URL's to hyperlinks is to import the entire table into Numbers. Numbers recognizes the https:// text and automatically converts it to a url. This is functionality that is virtually ubiquitous in contemporary software but IS NOT a part of the Excel portfolio (yet).
Copy the URL cell. Select the column. Then Past Special -> Formats only.
This worked great!
Implied but not said outright is that before copying the URL cell, you should first click into cell text and hit enter key. This converts a single cell to clickable URL.
So the 4-step process which works for any block of URL cells:
1) Hit Enter in first URL cell to make clickable
2) Then copy the linked URL cell
3) Select row/column/range of cells containing URLs you wish to format as clickable.
4) Paste Special>Formatting
