Excel Guides

Converting a Range of URLs to Hyperlinks in Excel

You can convert a range of URLs to hyperlinks in Excel by using the HYPERLINK function. This function will take the text of a URL and convert it into a hyperlink that you can click on. The syntax of the function is as follows:

=HYPERLINK(link_location, [friendly_name])

where link_location is the URL that you want to convert, and friendly_name is the text that you want to display for the hyperlink. If you omit the friendly_name, then the URL itself will be displayed.

To use this function, first select the cell or range of cells where you want the hyperlinks to appear. Then, enter the following formula into the cell or first cell in the range:

=HYPERLINK(link_location)

Replace link_location with the actual URL that you want to convert. For example, if you wanted to convert http://www.google.com, you would use the following formula:

=HYPERLINK("http://www.google.com")

If you wanted to display something other than the URL itself as the hyperlink text, then you would use the following formula:

=HYPERLINK(link_location, friendly_name)

For example, if you wanted to display "Google" as the hyperlink text instead of "http://www.google.com", then you would use the following formula:

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.