Your One-Stop Solution to Designing and Implementing Hyperlinks in Excel

Most of the time, in data analytics, one dashboard could not suffice to demonstrate all the critical reports. At times you might need the help of an additional dashboard to explain things in a broader spectrum. 

Attaching or linking multiple dashboards or linking multiple spreadsheets becomes crucial. Not just that, if you want to attach a webpage to your dashboard or spreadsheet, Hyperlinking is the ultimate solution.

This tutorial on HyperLinks in Excel will guide you with all the critical fundamentals of Hyperlinks in Excel and allow you to design and implement hyperlinks in excel for various applications.

PCP in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
PCP in Business Analysis

Hyperlinks in excel are simple and click-through shortcut jumps from excel to a different desired location. Using hyperlinks in excel, users can jump to a different webpage, spreadsheet, document, email, and many more.

Now, you will learn how to design and implement hyperlinks in Excel.

The hyperlinks in excel can be enabled in different ways. You will learn the prominently used and the simplest two ways.

Insert Menu

1. Navigate to the toolbar

2. Select the "Insert" option

3. Navigate to the "Links" group

4. Click on the "Link" option

5. The following dialogue box will appear on the screen

Shortcut Key Combination

There is a shortcut key combination for the same as follows:

  1. Choose a cell where you wish to insert a hyperlink
  2. Press “Ctrl / Command + K”
  3. The following dialogue box will appear on the screen

You will learn about the following: 

  • Hyperlinks in Excel to link a webpage
  • Hyperlinks in Excel to link an existing file
  • Hyperlinks in Excel to link a Worksheet
  • Hyperlinks to a specific/customized document
  • Hyperlinks in Excel to link an email

FREE Business Analytics With Excel Course

Start your Business Analytics Learning for FREEStart Learning
FREE Business Analytics With Excel Course

Hyperlinks in Excel to Link a Webpage

Hyperlinking to a webpage using excel is one of the shortest and easiest methods in using hyperlinks in Excel.

Just follow the simple steps below.

  • Write down the custom text you want to use for your hyperlink
  • Choose a cell and press the shortcut key combination CTRL / Command + K
  • A dialogue box will appear on screen as shown below
  • On the left menu, select the "Existing File Or Webpage" option
  • In the "Address" bar at the bottom, drop the website link as shown below 

Hyperlinks in Excel to Link an Existing File

  • Write down the custom text you want to use for your hyperlink
  • Select the cell and press the shortcut key combination CTRL / Command + K
  • A dialogue box will appear on screen as shown below
  • On the left menu, select the "Existing File Or Webpage" option
  • Use the "Browse" icon and navigate to the file you want to link to the sheet
  • Select "OK" 

Hyperlinks in Excel to Link a Worksheet

If you have multiple spreadsheets or dashboards in your workbook, and you want to navigate to the selected worksheet or dashboard using the hyperlinks in Excel, you could do that by following the steps below.

  • Write down the custom text you want to use for your hyperlink
  • Select the cell and press the shortcut key combination CTRL / Command + K
  • A dialogue box will appear on screen as shown below
  • On the left menu, select the "Place on This Document" option
  • Use the sheet list shown on the screen and navigate to your desired sheet 
  • Select a relevant cell address
  • Press "OK"

Hyperlinks to a Specific/ Customized Document

  • Write down the custom text you want to use for your hyperlink
  • Select the cell and press the shortcut key combination CTRL / Command + K
  • A dialogue box will appear on screen as shown below
  • On the left menu, select the "Create A New Document" option
  • Use the "Browse" option 
  • Write a customized name to your document 
  • Provide a relevant extension to your document (Example . TXT)
  • Select a location for your document
  • Select a relevant cell address
  • Press "OK"

Business Analyst Master's Program

Gain expertise in Business analytics toolsExplore Program
Business Analyst Master's Program

Hyperlinks in Excel to Link an Email

  • Write down the custom text you want to use for your hyperlink
  • Select the cell and press the shortcut key combination CTRL / Command + K
  • A dialogue box will appear on screen as shown below
  • On the left menu, select the "Email Address" option
  • Use the "email address" bar to add an address 
  • Press "OK"

You have reached the end of this ‘how to use hyperlinks in the Microsoft Excel’ tutorial.

Become job-ready with a globally recognized Business Analyst Certification Course. Sign-up today and enrich your career.

Conclusion

"AutoSum in Excel" can be your next stop. AutoSum in Excel is a simple aggregation function that can save a lot of time you invest in performing simple aggregation functions manually. The latest updates on MS Excel have introduced the AutoSum feature in Excel.

Interested in learning Microsoft Excel and receiving online training and certification in Business Analytics?

Check our Business Analytics certification course. Simplilearn's training is career-oriented certification. Business Analytics training by Simplilearn will guide the students with the fundamental of data analytics and statistics. After the training, you will devise insights from data to present your findings using executive-level dashboards and help you develop data-driven decision-making.

Please write your doubts to us in the comments section below. Our expert team will be happy to resolve all your questions.

About the Author

Ravikiran A SRavikiran A S

Ravikiran A S works with Simplilearn as a Research Analyst. He an enthusiastic geek always in the hunt to learn the latest technologies. He is proficient with Java Programming Language, Big Data, and powerful Big Data Frameworks like Apache Hadoop and Apache Spark.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
  • *According to Simplilearn survey conducted and subject to terms & conditions with Ernst & Young LLP (EY) as Process Advisors