Your One-Stop Solution To Designing And Implementing Hyperlinks In Excel

What Are Hyperlinks in Excel?

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.

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

Learn Excel Basics for Free

Introduction to MS ExcelSTART LEARNING

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

Become an AI-powered Business Analyst

With Purdue University's Business Analysis ProgramExplore Now

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"

Become The Highest-Paid Business Analysis Expert

With Business Analyst Master's ProgramExplore Now

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.