Your Guide to How Do i Create a Hyperlink In Excel
What You Get:
Free Guide
Free, helpful information about Productivity & Office Tools and related How Do i Create a Hyperlink In Excel topics.
Helpful Information
Get clear and easy-to-understand details about How Do i Create a Hyperlink In Excel topics and resources.
Personalized Offers
Answer a few optional questions to receive offers or information related to Productivity & Office Tools. The survey is optional and not required to access your free guide.
How to Create a Hyperlink in Excel: A Complete Guide
Hyperlinks in Excel aren't just for websites. You can link to other cells, sheets, files on your computer, email addresses, and external URLs — all from within a spreadsheet. Knowing which type of hyperlink fits your situation makes the difference between a cluttered workbook and one that's genuinely easy to navigate.
What Is a Hyperlink in Excel?
A hyperlink in Excel is a clickable element — attached to a cell or text — that takes you somewhere else when clicked. That destination could be:
- A website URL
- A specific cell or range in the same workbook
- A different sheet within the same file
- A separate file stored locally or on a network
- An email address that opens a new message
Excel stores hyperlinks differently from plain text. The cell displays the label you choose, while the underlying link points to the actual destination.
Method 1: Using the Insert Hyperlink Dialog (Most Common)
This is the most flexible approach and works across all major versions of Excel.
Steps:
- Click the cell where you want the hyperlink to appear
- Go to the Insert tab on the ribbon
- Click Link (sometimes labeled Hyperlink)
- The Insert Hyperlink dialog box opens
From here, the left panel shows four destination types:
| Option | What It Links To |
|---|---|
| Existing File or Web Page | A URL or local/network file |
| Place in This Document | A cell reference or named range in the workbook |
| Create New Document | A new file that Excel will create |
| E-mail Address | Opens the user's default email client |
Fill in the Text to display field at the top — this is what appears in the cell. Then set your destination and click OK.
Keyboard shortcut: Ctrl + K opens the same dialog instantly. 🔗
Method 2: Typing a URL Directly
If you type or paste a full URL (starting with http:// or https://) into a cell and press Enter, Excel usually auto-converts it into a clickable hyperlink. The cell shows the raw URL as both the label and the destination.
This works well for quick, informal use but gives you less control over the display text. To edit the label later, you'll need to use the Insert Hyperlink dialog or right-click → Edit Hyperlink.
Method 3: Using the HYPERLINK Function
For users who build dynamic spreadsheets or want to generate links programmatically, Excel's HYPERLINK function is more powerful than the dialog.
Syntax:
Examples: