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.
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
Shortcut Key Combination
There is a shortcut key combination for the same as follows:
- Choose a cell where you wish to insert a hyperlink
- Press “Ctrl / Command + K”
- 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
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"
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.
