HYPERLINK function. Set hyperlinks to jump to Web pages or files on disk.

Japanese version.

Specifying a URL or file path directly in a cell automatically formats it as a hyperlink, but this can be set with a function.

This makes it possible to control the link destination in a variable manner.

How it works

=HYPERLINK(link_location, friendly_name)
link_locationRequired argument.Specify the path or URL of the file to jump to.
Up to 255 characters.
friendly_nameValue specified in "link_location".Specify what to display in the cell.


If you omit the friendly_name, the cell will display the link as is.

If an friendly_name is set, the cell will display the friendly_name.



Microsoft Excel Functions Lookup & Reference