Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Insert a Hyperlink in Excel? 3 Easy Ways

How to Insert a Hyperlink in Excel? 3 Easy Ways

(Note: This guide on how to insert a hyperlink in Excel is suitable for all Excel versions including Office 365)

Hyperlinks are an important part of any application that you can use to access or refer to other data with just a click. Predominantly, the term “hyperlink” is used to refer to embedding a webpage into a piece of text. 

In Excel, you can do much more than just hyperlinking a webpage to the text. You can embed other worksheets and workbooks, create a new workbook, and even create a hyperlink to an e-mail. Additionally, these hyperlinks not only pertain to text. You can also add hyperlinks to charts and images. 

In this article, you’ll learn how to insert hyperlink in Excel in 3 easy ways.

You’ll Learn:

  • Using the Insert Main Menu
  • Using the HYPERLINK Function
  • By Dragging and Dropping
Download Sample Workbook for Insert a Hyperlink Function in Excel
Download Sample Workbook for Insert a Hyperlink Function in Excel

Watch our video on how to insert hyperlinks in Excel

Related Reads:

How to Convert Excel to Word? 2 Easy Methods

How to Filter in Excel? A Step-by-Step Guide

How to Create an Excel Heat Map? 5 Simple Steps

Insert a Hyperlink in Excel

Using the Insert Main Menu

This is the most common method to insert a link into an Excel cell and it offers a variety of functionalities and options. 

Insert a Webpage link

Here, let us insert the link “https://www.simonsezit.com/” in the cell with anchor text as SimonSezIT.

  • To insert a hyperlink, first, select a cell. You can select an empty cell or a cell that already has text in them. This text will act as the anchor text for the link.
  • After selecting a cell where you want to insert the link, navigate to Insert. Under the Link section, click Link.
  • This opens up a new dialog box.
Insert hyperlink in Excel as Webpage
Insert hyperlink in Excel as Webpage
  • In the Address textbox, enter the correct address of the webpage. It is always a better practice to copy and paste the web address than to enter them manually. (clubdeportestolima)
  • If you haven’t added any anchor text, you can enter them in the Text to Display textbox.
Enter the link for the webpage
Enter the link for the webpage
  • Click OK.
  • This inserts the webpage link into the cell which contains the anchor text. When you click on the text, you will be directed to the respective webpage.
The hyperlink is inserted in the cell
The hyperlink is inserted in the cell

Insert Another File

Using the same option, you can hyperlink the anchor text to insert an existing file. This will greatly minimize the efforts to search for, navigate, and open the file. Here, let us insert the Excel workbook “Funnel Chart in Excel” in the anchor text “Funnel Chart in Excel”.

  • In the Insert Hyperlink textbox, click on Existing File or Web Page. In the main pane, search for the location of the file and select it. 
  • Click OK. 
Insert a file into a hyperlink in Excel
Insert a file into a hyperlink in Excel
  • This inserts the selected file in your local drive to the cell. 
  • When you click on the link, the default program that is used to open the file opens.

Note: Before you insert the file, make sure the file you’re inserting is properly saved.

Insert a Worksheet

In case you have multiple worksheets in a workbook, searching for that particular worksheet might be a little difficult. In such a case, you can hyperlink other worksheets of the same workbook. (Tramadol) Let us link the Sample Sheet onto a cell in the Hyperlink Sheet.

  • Go to Insert and click on Link. In the Insert Hyperlink dialog box, click on Place in this Document. 
  • Enter the Cell Reference and select the sheet that you want to hyperlink.
  • Click OK.
Insert a worksheet into a hyperlink in Excel
Insert a worksheet into a hyperlink in Excel
  • If you click on the cell or the text, it will take you to the selected workbook.

Insert a New Workbook

Using the Create New Document option, you can create a new Excel workbook with just a click.

  • Go to Insert and click on Link. The Insert Hyperlink dialog box opens. On the left side, click on Create New Document. Enter the name of the new document and click OK. 
  • You can change the file location using the Change button. To open the new workbook only when you click on the anchor text, click on the Edit the new document now button.
  • Click OK.
Create a hyperlink for new workbook in Excel
Create a hyperlink for new workbook in Excel
  • This will insert the anchor text in the selected cell. If you click on the cell or the text, a new workbook will open. 

Insert an E-mail address

You can create a hyperlink to a custom e-mail address by following the steps mentioned below.

  • In the Insert Hyperlink dialog box, click on E-mail Address.
  • In the Text to display textbox, enter the anchor text that you want to appear in the cell. Then, enter the E-mail address of the recipient and the Subject of the mail. 
Hyperlink an email in Excel
Hyperlink an email in Excel
  • This inserts the hyperlink into the selected cell.

When you click on the hyperlink, Excel redirects you to the default mail application where you can compose, edit, and send the mail.

Note: The ScreenTip button that appears in every option is used to add the text to display when you hover over the cell or the text.

Suggested Reads:

How to Delete a Named Range in Excel? 3 Easy Methods

How to Record a Macro in Excel? In 6 Easy Steps (For Dummies)

How to Use CONVERT Function in Excel? A Step-by-Step Guide

Using the HYPERLINK Function

There is almost a function for every operation in Excel. Using the HYPERLINK function, you can insert hyperlinks into cells in Excel.

Syntax

=HYPERLINK(hyperlink,anchortext)

The hyperlink function takes two arguments. Here, the hyperlink is the link that directs you to the webpage and the anchortext is the text in which the link will be embedded.

  • To use the HYPERLINK function, select a destination cell. 
  • Enter the formula in the destination cell and press Enter.
Insert a webpage using HYPERLINK function
Insert a webpage using HYPERLINK function

In the same way, you can also insert a hyperlink to a file. Just enter the file location in the first argument and the anchor text in the second argument. 

Insert a file using HYPERLINK function
Insert a file using HYPERLINK function

Note: Always enclose the hyperlink and anchor text parameter using double quotes.

By Dragging and Dropping

This is an easy and simple way to insert a hyperlink in Excel. Just by dragging and dropping a cell, you can insert the hyperlink to a cell.

  • First, select a cell and enter the anchor text.
  • Move the mouse pointer to the corner of the cell. You can see the pointer turn to a four-sided movable pointer. 
  • Right-click and drag the cell to a new position or place it in the same position. 
  • Now, leave the mouse button and click on Create Hyperlink Here.
Click on Create Hyperlink Here
Click on Create Hyperlink Here
  • This hyperlinks the anchor text with the current workbook as default. 
  • You can then copy and paste the hyperlink onto a new worksheet or a new workbook.

If you want to change the hyperlink, right-click on the link and click on Edit Hyperlink. 

Edit, Delete, or Remove a Hyperlink

Though hyperlinks are useful in a variety of perspectives, there are some instances where they might not be necessary. In some cases, you will have to change the hyperlink or remove them from the anchor text.

  • To edit the hyperlink, first, select the cells with the inserted hyperlink.
  • Now, right-click and select Edit Hyperlink.
  • This in turn opens the Insert Hyperlink dialog box. Using this, you can change the embedded link or file based on your choice.
Click on Edit Hyperlink
Click on Edit Hyperlink

To delete a hyperlink, right-click on the link and click on Remove Hyperlink. If you want to know more ways to delete hyperlinks, read our article on how to remove hyperlinks in Excel. 

Also Read:

How to Create Excel Drop Down List With Color?

How to Insert Watermark in Word? 3 Easy Ways

How to Use the Excel TREND Function? A Step-by-Step Guide

Frequently Asked Questions

How to insert a hyperlink in an image in Excel?

To insert an image in Excel, first, insert an image using the Insert option. From the same Insert option, you can find the Link option. Click on it to open the Insert Hyperlink dialog box. Then, choose the type you want to insert the hyperlink and add them.

Why is the embedded Excel workbook not opening when I click on the hyperlink?

The workbook is inserted as a hyperlink onto the cell by using its file location/address. If you happen to change the file location, the hyperlink might not work and Excel throws a pop-up saying “Cannot open the Specified File”.

What is the shortcut key to insert hyperlink in Excel?

The easiest way to hyperlink in Excel is by using the shortcut key Ctrl+K. This opens the Insert Hyperlink text box where you can insert the URL or file location.

Closing Thoughts

Knowing how to insert hyperlinks in Excel will mitigate a lot of efforts to search, locate, and open any webpage or another reference file.

In this article, we saw how to insert a hyperlink in Excel in 3 ways. You can either insert the hyperlink from the Insert main menu, using the HYPERLINK function or simply by dragging and dropping. Additionally, you can also choose to hyperlink a webpage or any other file. 

Please visit our free resources center for more high-quality Excel guides. 

Ready to take the next step and hone your skills in Excel?

Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 140+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Create Credit Memos in QuickBooks 2019

How to Add Vendors in QuickBooks 2018

Jira Avatar – An Easy Beginner’s Guide

How to setup rules in Microsoft Outlook 2013 – Part 1

How to Create Hyperlinks in Microsoft Word 2013

How to Calculate Time in Excel? 2 Distinct Types

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)