How to use Hyperlink function in Excel

The Hyperlink function in Microsoft Excel is used to create a hyperlink to a specific URL, file, or email address.

To use the Hyperlink function in Excel, follow these steps:

  1. Select the cell where you want to insert the hyperlink.
  2. Type =HYPERLINK(” followed by the URL, file path, or email address you want to link to, enclosed in double quotes. For example: =HYPERLINK(““) =HYPERLINK(“C:\MyFiles\MyDocument.docx”) =HYPERLINK(““)
  3. Add a comma and then type the display text for the hyperlink, enclosed in double quotes. For example: =HYPERLINK(“”,”Go to Google”)
  4. Press Enter. The display text in the selected cell will now be a hyperlink to the specified URL, file, or email address.

You can also right-click on a cell and select “Hyperlink” from the context menu. In the “Insert Hyperlink” dialog box, you can enter the information for the hyperlink and choose the display text.

Note: When you click on a hyperlink in Excel, it will open the linked item in the default web browser or program associated with the file type.

See also  How to Use PROPER Function