Before We learn How to create Hyperlink, let’s Learn what is Hyperlink and in where we can use it.
A Hyperlink is a reference to a document, a location or an action that the reader can directly follow by selecting the link. Hyperlinks are used extensively on the Internet and are generally Words highlighted in Underline Blue<– Like that.
- Existing File
- Existing Web Page
- Place in This Document
- Create a New Document
- Send an Email Link
When and Where?
For quick access to related information in another file or on a web page, you can insert a hyperlink in a Microsoft Excel worksheet cell. You can also insert hyperlinks in specific chart elements or images. The use of Hyperlinks in Excel has been extended to a number of areas and this includes:
- Opening Files (of any type)
- Opening Web Pages (Internet or Intranet)
- Jumping/Navigating to locations within an existing document
- Creating New Documents (Excel files only)
- Sending Emails
Case Study: Imagine that you want to create an excel sheet from where you can open your important files, web links, excel sheet, send an e-mail and much more by using a single click of your mouse! Yes, You can create this dynamically!!
Let’s go through the following steps to create this
Step 1: Create a table like above picture that contains some column headings Like Web Page, File, New File, Workbook, E-Mail etc.
Step 2: Enter a value in a cell under Web page column like “Yoda Learning”.
Step 3: Click on the cell contains “Yoda Learning” and click Insert tab.
Step 4: On the Insert tab, in the Links group, click Hyperlink.
Step 5: Insert Hyperlink Dialog box will be opened. Under Link to, click Existing File or Web Page.
Step 6: In the Address box type the web link of Yoda Learning: “https://yodalearning.com/” then click OK.
Your hyperlink is created successfully! Now if you click on that cell it will open that web page in a browser.
- Open Workbook
- Select a cell which contain text
- Click Insert Tab
- On the Insert tab, in the Links group, click Hyperlink
Step 1: Enter a value under File column with a file name you want to open from your computer. Here we have entered the name “Tutorial”.
Step 2: Open Hyperlink and from Insert Hyperlink dialog box click the Current folder and select your file for the hyperlink. Click OK.
Your Hyperlink to file created successfully! Now you can open your this file from this excel sheet by a single click on this cell.
- Open Excel
- Select a cell which contain text
- Open Hyperlink and from Insert Hyperlink dialog box click the Current folder
- Select your file for the hyperlink.
- Click OK.
Think: Imagine that you need to create a doc file and next few days will work on that continuously. You can create this new file with hyperlink easily!
Step 9: Type a value under the New File column. Here we typed Word File.
Step 10: Open Hyperlink for this cell. Insert Hyperlink Dialog box will appear. Under Link to, click Create New Document. In the Name of new Document type the name of your new file and select the directory by click Change button. In this example, we are going to create a doc file named “Word File.docx”. Click OK.
Your new doc file and Hyperlink is created now! Now you can open your new file by single click on that cell.
Step 11: create a new sheet and in cell A1 type “Workbook Hyperlink”. We will create a hyperlink in our previous sheet for this new cell of new sheet. Click to a new cell and In the Name box to the left of the formula bar, type the name of the cells, and then press ENTER. Here we type Workbook as a name.
Step 12: Now back to our previous sheet and type under Workbook column “Workbook”. Click on it and open Insert Hyperlink Dialog box as like the previous process.
Step 13: Under Link to click Place in This Document. Select “New” from Cell Reference tree to select our New sheet of the same excel file and select Workbook from Defined Name tree. (Remember we created this Name “Workbook” for the cell “Workbook hyperlink” of New Spreadsheet. To be listed in Defined Name tree you must change the name of that particular cell from Name box). Now click OK.
Our Workbook hyperlink is created. Now when you click on this cell, it will jump to the New sheet’s new cell Workbook hyperlink.
Step 14: Type Send e-mail in a cell under the E-mail column. Open hyperlink for this cell.
Step 15: Under Link to click E-mail Address. Type the email address that you want to use and type the Subject. Click OK.
Your hyperlink to an email address is created successfully! Now you send mail to that particular mail address with a single click on that cell!
If you want to Remove or Edit hyperlink, just right click and click Remove Hyperlink for remove and Edit Hyperlink to edit your cell.
Just click on that object and open hyperlink and follow the same process to create a hyperlink.
Tips 4: Want to create or change the ScreenTip when you mouse hover over a hyperlinked cell?!
Click on a cell and Open Edit Hyperlink to add ScreenTip for that cell-like above picture. Click ScreenTip. Now Type the ScreenTip text, then click OK.
- Type Send e-mail in a cell under the E-mail column.
- Open hyperlink for this cell.
- Under Link to click E-mail Address.
- Type the email address that you want to use and type the Subject.
- Click OK.