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:
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:
The content in the linked cell has underlined text when moving the mouse over the changed content:
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:
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:
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
Step 3: Finally, you created the Hyperlink link in Excel:
When you click on News & Events -> the system automatically opens the browser to access to the website http://soha.vn/ created the link before:
The above is a detailed guide on how to create Hyperlink to link in Excel. Good luck!
You should read it
- How to disable Hyperlink in Excel
- How to create links in PowerPoint
- How to create hyperlinks in excel is extremely useful
- Instructions on how to create Hyperlink in Excel
- This is a simple way to find and delete Hyperlink in Excel
- How to use the Hyperlink function in Excel
- Create Hyperlink in Excel
- How to delete the link, remove Hyperlink in Word
May be interested
- Attach files to PDF files with Foxit Readerthe 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 datahow 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 Excelin 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 Excelthe 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 Excelthe 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 Excelby 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