ExcelTutorials

Tricks to create Hyperlink in Excel | ‘How to’

4 Mins read

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

Excel Vlookup Formula

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

Tricks to create hyperlink to webpage

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.

Enter a value in a cell under webpage

Step 2: Enter a value in a cell under Web page column like “Yoda Learning”.

Click on insert tab

Step 3: Click on the cell where you want to create Hyperlink contains “Yoda Learning” and click the Insert tab.

On the link group click on hyperlink

Step 4: On the Insert tab, in the Links group, click Hyperlink.

Another shortcut to get 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.

Insert Hyperlink dialog box will be open

Step 5: Insert Hyperlink Dialog box will be opened. Under Link to, click Existing File or Web Page.

In the weblink add dialog box yodalearning.com

Step 6: In the Address box type the web link of Yoda Learning: “https://yodalearning.com/” then click OK.

Your hyperlink is created successfully

Your hyperlink is created successfully! Now if you click on that cell it will open that web page in a browser.

Create a hyperlink to a file

Excel Vlookup formula – Guidebook

Excel Vlookup Formula

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:

  1. Open Workbook
  2. Select a cell where you want to create Hyperlink.
  3. Click Insert Tab
  4. On the Insert tab, in the Links group, click Hyperlink
  5. 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”.

Insert Hyperlink dialog box click Current folder

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 a file create successfully

Your Hyperlink to file created successfully! Now you can open this file from this excel sheet by a single click on this cell.

Create a new file using hyperlink

Summary:

How to Create a Hyperlink to a File:

  1. Open Excel
  2. Select a cell where you want to create a Hyperlink
  3. Open Hyperlink and from Insert, Hyperlink dialog box click the Current folder
  4. Select your file for the hyperlink.
  5. 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.

Insert Hyperlink Dialog box will be appeared

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

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 workbook

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.

Click on it and open Insert Hyperlink Dialog box as like previous process

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.

Under Link to click Place in This Document

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

Our Workbook hyperlink is created. Now when you click on this cell, it will jump to the New sheet’s new cell Workbook hyperlink.

Create hyperlink to an E-mail

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.

Under Link to click E-mail Address

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

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!

How to remove or edit a hyperlink

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.

Want to create or change the ScreenTip when you mouse hover over a hyperlinked cell

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.

Now go to that particular cell and hover your mouse to see the Magic

Summary:

How to Create a hyperlink to an E-mail:

  1. Type Send e-mail in a cell under the E-mail column.
  2. Open hyperlink for this cell.
  3. Under Link to click E-mail Address.
  4. Type the email address that you want to use and type the Subject.
  5. 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

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…