How to create Hyperlink to link in Excel

The following article details you how to create Hyperlink to link in Excel.

You can create links from Excel files to another Excel file, a sheet is right there in the Excel file, you can even create links to a website on the Internet, or to an email address.

Step 1: Put the cursor in the data box you want to create a link -> on the Insert tab -> Link -> Link:

How to create Hyperlink to link in Excel Picture 1

Step 2: The Insert Hyperlink dialog box appears with the following options:

1. Create a link to a website on the Internet

Click Existing File or Web page (1) to select a link to a website. In the section:

- Text to display (2): Enter the description of the link.

- Address (3): Enter the path of the site

-> Finally, click OK -> You have created the link to the website:

How to create Hyperlink to link in Excel Picture 2

The content in the linked cell has underlined text when moving the mouse over the changed content:

How to create Hyperlink to link in Excel Picture 3

2. Create a link to a sheet in the file you are using

Click Place in this Document to select the link to the sheet in the data file. In the section:

- Text to display : Enter the text of the description for the link.

- Or Sheet a place in this document: select the sheet to create links

Finally, click the OK button you created the link to the sheet in Excel:

How to create Hyperlink to link in Excel Picture 4

3. Create a link to a newly created data file

Click Create New Document to link to the newly created data file. In the section:

- Text to display: Enter a description for the link

- Name of New document: Enter a name for the new data file you want to create.

- Full path: Select the path to save the file by clicking Change.

Finally click OK and you have finished creating the link to a newly created file:

How to create Hyperlink to link in Excel Picture 5

4. Create link to email address

Click on the E-mail Address to create the link to the e-mail. In the section:

- Text to display: Enter a description for the link

- E-mail Address: Enter the email address to create a link

- Subject field: Enter subject for email

How to create Hyperlink to link in Excel Picture 6

Step 3: Finally, you created the Hyperlink link in Excel:

How to create Hyperlink to link in Excel Picture 7

When you click on News & Events -> the system automatically opens the browser to access to the website http://soha.vn/ created the link before:

How to create Hyperlink to link in Excel Picture 8

The above is a detailed guide on how to create Hyperlink to link in Excel. Good luck!

4 ★ | 1 Vote

May be interested

  • Attach files to PDF files with Foxit ReaderPhoto of Attach files to PDF files with Foxit Reader
    the following article will guide you how to attach files to pdf files with foxit reader.
  • How to combine 2 or more cells in Excel without losing dataPhoto of How to combine 2 or more cells in Excel without losing data
    how to combine 2 or more cells in excel without losing data. when merging cells containing data into 1 cell, excel retains the data in the first cell only, data in the remaining cells are deleted. so to retain all data in the cells you need to merge, you cannot use the feature
  • How to split strings in ExcelPhoto of How to split strings in Excel
    in excel when working with character strings, there are many cases where it is necessary to split a string to use the data, but the amount of data needs to be separated quite large, if merely manually doing it takes a lot of time and effort. strength. the following article guides to
  • How to calculate the average in ExcelPhoto of How to calculate the average in Excel
    the following article guides you in detail how to calculate the average in excel. there are 2 ways to calculate the average value: - calculate the average value according to the usual calculation formula. - calculate the average value using the average function.
  • Calculation of age from date of birth in ExcelPhoto of Calculation of age from date of birth in Excel
    the following article will guide you how to calculate the age from date of birth in excel so you can calculate the exact number of standard age in years, months and days. in the process of calculating age based on date of birth, the following cases occur: - case 1: calculates the usual age
  • Convert commas to dots in ExcelPhoto of Convert commas to dots in Excel
    by default, the number format in excel follows international standards separating thousands with commas and decimals as dots. this way of writing is in contrast to the vietnamese writing style, so this article i will guide how to change commas