How to convert a URL into a hyperlink automatically

by | Apr 20, 2018 | Excel Tips & Tricks

How to convert URLs into hyperlinks automatically

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.

Syntax

=HYPERLINK(URL, [optional friendly name])

Steps

  1. Start with =HYPERLINK(
  2. Select or type in the reference that contains the URL itself (i.e. C9)
  3. Add a friendly name (i.e. B9)
  4. Close the formula with )
  5. Copy down the formula as necessary for other rows

How

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).

=HYPERLINK(C9,B9)

=HYPERLINK("www.spreadsheetweb.com","Home")