Lookup & Reference
All versions
◉ 38 views
=HYPERLINK()
The HYPERLINK function creates a shortcut that jumps to another location in the current workbook, or opens a document stored on a network server, an intranet, or the Internet. When you click a cell that contains a HYPERLINK function, Excel jumps to the location listed, or opens the document you specified.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=HYPERLINK(link_location, [friendly_name])
Hover argument names in the table for details.
Output typeText
Popularity45 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =HYPERLINK() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
link_location |
Text | Required | The path and file name to the document to be opened. Link_location can refer to a place in a document — such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a Microsoft Word document. The path can be to a file that is stored on a hard disk drive. The path can also be a universal naming convention (UNC) path on a server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL) path on the Internet or an intranet. Note Excel for the web the HYPERLINK function is valid for web addresses (URLs) only. Link_location can be a text string enclosed in quotation marks or a reference to a cell that contains the link as a text string. If the jump specified in link_location does not exist or cannot be navigated, an error appears when you click the cell. |
friendly_name |
Any type | Optional | The jump text or numeric value that is displayed in the cell. Friendly_name is displayed in blue and is underlined. If friendly_name is omitted, the cell displays the link_location as the jump text. Friendly_name can be a value, a text string, a name, or a cell that contains the jump text or value. If friendly_name returns an error value (for example, #VALUE!), the cell displays the error instead of the jump text. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A6 |
=HYPERLINK("\\FINANCE\Statements\1stqtr.xlsx", D5) |
A7 |
=HYPERLINK("D:\FINANCE\1stqtr.xlsx", H10) |
A8 |
=HYPERLINK("[C:\My Documents\Mybook.xlsx]Totals") |
A9 |
=HYPERLINK("[Book1.xlsx]Sheet1!A10","Go to Sheet1 > A10") |
A10 |
=HYPERLINK("[Book1.xlsx]January!A10","Go to January > A10") |
A11 |
=HYPERLINK(CELL("address",January!A1),"Go to January > A1") |
A12 |
=HYPERLINK($Z$1) |
A17 |
=HYPERLINK("\\FINANCE\Statements\1stqtr.xlsx", D5) |
A18 |
=HYPERLINK("D:\FINANCE\1stqtr.xlsx", H10) |
A19 |
=HYPERLINK("[C:\My Documents\Mybook.xlsx]Totals") |
A20 |
=HYPERLINK("[Book1.xlsx]Sheet1!A10","Go to Sheet1 > A10") |
A21 |
=HYPERLINK("[Book1.xlsx]January!A10","Go to January > A10") |
A22 |
=HYPERLINK(CELL("address",January!A1),"Go to January > A1") |
A23 |
=HYPERLINK($Z$1) |
Example 1
=HYPERLINK("https://www.example.com", "Login")
Example 2
=HYPERLINK("#Sheet2!A1", "Go to Sheet2")
⚠ Common Errors
#VALUE!
If friendly_name returns an error value (for example, #VALUE!), the cell displays the error instead of the jump text.
Fix: بررسی کنید friendly_name خطا برنگرداند؛ فرمول یا ارجاع آن را اصلاح کنید یا از IFERROR برای مدیریت خطا استفاده کنید.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!