Excel can detect URLs and convert them into hyperlinks when you press the Enter key on that particular cell. When working with a large data set with thousands of rows you may not want to go to each cell and repeat this process. Enter the HYPERLINK function.
=HYPERLINK(URL, [optional friendly name])
- Start with =HYPERLINK(
- Select or type in the reference that contains the URL itself (i.e. C9)
- Add a friendly name (i.e. B9)
- Close the formula with )
- Copy down the formula as necessary for other rows
The HYPERLINK function converts a URL into a hyperlink and has 2 arguments. The first one is the path and the second is the friendly name (if you don’t want that whole URL is to be shown).