How to use the HYPERLINK function in Excel

This function creates a clickable hyperlink to a document, webpage, or file location.

Syntax:

HYPERLINK(link_location; [friendly_name])

Arguments:

• link_location (required):
  • A text string specifying the path or URL (e.g., « C:\Files\Report.docx » or « https://example.com »).
• friendly_name (optional):
  • The display text in the cell (e.g., « Open Report »). If omitted, the link_location is shown.

Background:

• Dynamic Links: Unlike static links (Ctrl+K), this function allows formula-based links (e.g., linking to a file path stored in another cell).
• Editing: To modify the hyperlink, click and hold the cell until the cursor turns into a cross.
• Errors: Invalid paths display an error message.

Examples:

1. Web Link (Microsoft Office Online):

=HYPERLINK(http://office.microsoft.com/de-de/default.aspx »; « Internet test ») 

1. • Displays: « Internet test » (click to open the URL).
2. Local Word Document:

=HYPERLINK(« document.docx#highlight »; « Word test ») 

1. • Opens document.docx and jumps to the text « highlight ».
   • Displays: « Word test ».
2. Alternative Method (Copy-Paste Hyperlink):
   • In Word: Select text → Copy.
   • In Excel: Right-click → Paste as Hyperlink.

Note: Right-click the cell to edit or remove the hyperlink.