Tutorial Playlist

Excel Tutorial

Overview

Your One-Stop Solution to Know About Excel Worksheets

Lesson - 1

Your One-Stop Solution For Excel UserForms

Lesson - 2

The Best Guide on How to Send an Email in Excel

Lesson - 3

Your One-Stop Solution That Will Help You Learn How to Convert PDF to Excel

Lesson - 4

A One-Stop Solution for Acing the Excel MIS Report

Lesson - 5

All You Need to Know About Barcode in Excel

Lesson - 6

Your One-Stop Solution to Learn Mail-Merge in Excel and Its Implementation

Lesson - 7

A Comprehensive Guide on Excel Flash Fill

Lesson - 8

Slicers in Excel: The Ultimate Guide to Help You Design and Develop Excel Slicers

Lesson - 9

One-Stop Solution to Learn Everything About Excel Budget Template

Lesson - 10

All You Need to Learn About Match Function in Excel and Its Real-Time Implementation

Lesson - 11

Everything You Need to Learn on How to Create a Pivot Table From Multiple Sheets

Lesson - 12

The Major Fundamentals About XLookUp in Excel Along With Practical Examples

Lesson - 13

The Ultimate Guide to Learn How to Compare Two Columns in Excel

Lesson - 14

The Best Guide and Your One-Stop Solution to Master the Fill Series in Excel

Lesson - 15

What Is the DATE Function in Excel and How to Implement It?

Lesson - 16

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

Lesson - 17

One-Stop Solution to Master Everything You Need to Know About Auto-Sum in Excel

Lesson - 18

DAX in Excel: The Complete Guide for DAX Functions and Formulas in Excel

Lesson - 19

A Perfect Guide for All You Need to Know About Data Formatting in Excel

Lesson - 20

The Perfect Guide to Learn How to Add Columns in Excel

Lesson - 21
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.

Post Graduate Program in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
Post Graduate Program 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.