Before We learn How to create Hyperlink, let’s Learn what is Hyperlink and where we can use it.
What are Hyperlinks?
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.
Excel Vlookup formula – Guidebook
Bored of downloading text heavy / copy-pasted eBooks?
If Yes, you will enjoy this guidebook on ‘Excel Vlookup Formulas’ – VLOOKUP, HLOOKUP, MATCH & INDEX.
Below are the 5 Types of Hyperlinks:
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, weblinks, 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
Steps to Create a Hyperlink to a web page in Excel:
Step 1: Create a table like the 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 where you want to create Hyperlink contains “Yoda Learning” and click the Insert tab.
Step 4: On the Insert tab, in the Links group, click Hyperlink.
Tips 1: There is another shortcut way also to get Hyperlink. Just Right-click the cell and then click Hyperlink, or you can press Ctrl+K.
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.
Excel Vlookup formula – Guidebook
Bored of downloading text heavy / copy-pasted eBooks?
If Yes, you will enjoy this guidebook on ‘Excel Vlookup Formulas’ – VLOOKUP, HLOOKUP, MATCH & INDEX.
Summary:
Steps to Create Hyperlink to a webpage:
- Open Workbook
- Select a cell where you want to create Hyperlink.
- Click Insert Tab
- On the Insert tab, in the Links group, click Hyperlink
- Done
How to Create a Hyperlink to a File in Excel:
Step 1: Enter a value under the 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 this file from this excel sheet by a single click on this cell.
Summary:
How to Create a Hyperlink to a File:
- Open Excel
- Select a cell where you want to create a Hyperlink
- Open Hyperlink and from Insert, Hyperlink dialog box click the Current folder
- Select your file for the hyperlink.
- Click OK.
15 Excel Data Cleaning Tricks Guidebook
Bored of downloading text heavy / copy-pasted eBooks? If Yes, you will enjoy this guidebook (43 pages)
Create a new file using Hyperlink in Excel:
Think: Imagine that you need to create a doc file and the next few days will work on that continuously. You can create this new file with a hyperlink easily!
Step 1: Type a value under the New File column. Here we typed Word File.
Step 2: 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.
Create a Hyperlink to a particular cell of the workbook:
Step 1: 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 the 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 2: Now back to our previous sheet and type under Workbook column “Workbook”. Click on it and open Insert Hyperlink Dialog box as the previous process.
Step 3: 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 the Defined Name tree. (Remember we created this Name “Workbook” for the cell “Workbook hyperlink” of the 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.
How to Create a hyperlink to an E-mail:
Step 1: Type Send e-mail in a cell under the E-mail column. Open hyperlink for this cell.
Step 2: 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!
Tips 2: How to remove or edit a hyperlink?
If you want to Remove or Edit hyperlink, just right click and click Remove Hyperlink to remove and Edit Hyperlink to edit your cell.
Tips 3: You can also create a hyperlink for another object like an image or graph in your excel sheet.
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.
Summary:
How to Create a hyperlink to an E-mail:
- 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.
15 Pivot Tables Tricks for Pros
15 Pivot Table tricks to make your Excel data analysis smarter! 5,600+ downloads.
Most Popular Tricks are #3, #7 & #12