In most cases, one dashboard is insufficient to show all of the important findings in data analytics. Sometimes, you may require the assistance of a second dashboard to provide a wider range of explanations.
It becomes essential to attach or integrate numerous spreadsheets or dashboards. Not only that, but hyperlinking is the best way to add a webpage to your spreadsheet or dashboard.
Excel has hyperlinks that allow you to go through different data. Insert hyperlink in Excel as it will enable users to navigate to various websites, spreadsheets, documents, emails, and much more.
How Can I Create and Use Hyperlinks in Excel?
There are various ways to enable hyperlinks in Excel. You will discover the two most popular and straightforward methods.
Insert Menu:
- Look for the toolbar.
- Click on the “Insert” menu.
- Select the group “Links”
- Select the “Link” menu item.
- The screen will display the conversation box that follows.
Shortcut Key Combination
The following key combination can be used as a shortcut for the same:
- In the spreadsheet, select the cell that you want to add a hyperlink to.
- Then, hit “Ctrl / Command + K.”
- The screen will display the dialog box that follows.
You’ll get knowledge of the following:
- Excel hyperlinks that connect to a webpage
- Excel hyperlinks to connect an already-existing file
- Excel hyperlinks to connect a worksheet
- Links leading to a particular or personalized document
- Excel hyperlinks to connect an email
Excel Hyperlinks for Connecting a Webpage
One of the simplest and quickest ways to use hyperlinks in Excel is to link to a webpage.
Just adhere to the easy steps listed below.
- Jot down the personalized text you wish to utilize as your hyperlink.
- Select a cell and hit the shortcut combination on your keyboard. Command/Control + K
- As seen below, a dialogue box will pop up on the screen.
- Choose the “Existing File Or Webpage” option from the menu on the left.
- Drop the website link as indicated below into the “Address” bar at the bottom.
Excel Hyperlinks to Connect an Already-Existing File
- Jot down the personalized text you wish to utilize as your hyperlink.
- After choosing the cell, hit the shortcut key combination. Command/Control + K
- As seen below, a dialogue box will pop up on the screen.
- Choose the “Existing File Or Webpage” option from the menu on the left.
- To link a file to a sheet, use the “Browse” icon to find the file.
- Choose “OK”
Excel Hyperlinks for Connecting a Worksheet
The procedures listed below might help you get to the desired worksheet or dashboard using Excel’s hyperlinks if your workbook has numerous spreadsheets or dashboards.
- Jot down the personalized text you wish to utilize as your hyperlink.
- After choosing the cell, hit the shortcut key combination. Command/Control + K
- As seen below, a dialogue box will pop up on the screen.
- Choose the “Place on This Document” option from the menu on the left.
- Navigate to the sheet you want using the sheet list displayed on the screen.
- Choose a pertinent cell phone number.
- Hit the “OK” button.
Hyperlinks to a Certain or Custom Document
- Jot down the personalized text you wish to utilize as your hyperlink.
- After choosing the cell, hit the shortcut key combination. Command/Control + K
- As seen below, a dialogue box will pop up on the screen.
- Choose the “Create A New Document” option from the menu on the left.
- Make use of “Browse”
- Give your document a unique name.
- Give your document a pertinent extension (Example. TXT).
- Choose a place for your file.
- Choose a pertinent cell phone number.
- Hit the “OK” button.
You can use hyperlinks for more than just storing data. They are essential for building functional dashboards and can guide you through challenging workbooks.
Featured Image Source: https://img.freepik.com/free-photo/spreadsheet-marketing-budget-report-file-concept_53876-120910.jpg?size=626&ext=jpg&ga=GA1.1.1778210618.1698672001&semt=sph