HYPERLINK Function in Excel: Syntax, Examples and Free Practice
HYPERLINK is an Excel Lookup & Reference function. Creates a clickable shortcut that jumps to another location.
HYPERLINK syntax
Arguments
link_location: The location the link should openfriendly_name: The text displayed for the link (optional)
When to use HYPERLINK
HYPERLINK is used to pull matching data from one part of a workbook into another.
Practice HYPERLINK online, free
Open the live Excel-style spreadsheet and try HYPERLINK yourself. No Excel install or sign-up needed to start.
Practice HYPERLINK now →More Lookup & Reference functions
Frequently asked questions
What does the HYPERLINK function do in Excel?
Creates a clickable shortcut that jumps to another location.
What is the syntax of HYPERLINK in Excel?
The syntax is =HYPERLINK(link_location, [friendly_name]). link_location: The location the link should open; friendly_name: The text displayed for the link (optional).
Where can I practice HYPERLINK online for free?
Open the free live spreadsheet on Cellgrids and try HYPERLINK yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts