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

  • How to delete the link, remove Hyperlink in WordHow to delete the link, remove Hyperlink in Word
    when you want to delete the entire link, the hyperlink available in word manually each link will take a lot of time. so how to quickly disable links on word?
  • How to Insert Hyperlinks in Microsoft ExcelHow to Insert Hyperlinks in Microsoft Excel
    this wikihow teaches you how to create a link to a file, folder, webpage, or new document in microsoft excel. you can do this on both the windows and mac versions of excel. open an excel document. double-click the excel document in which...
  • How to open links in Word, Outlook does not need the Ctrl keyHow to open links in Word, Outlook does not need the Ctrl key
    this article will show you how to turn off the ctrl + click feature when opening hyperlinks in word and outlook.
  • How to turn off Update Link notification in ExcelHow to turn off Update Link notification in Excel
    when an excel file comes from a variety of sources, you will often find the message to request a link update quite annoying.
  • How to delete links in Excel, delete hyperlinks in ExcelHow to delete links in Excel, delete hyperlinks in Excel
    what if you want to disable hyperlink links in excel? there are many ways for us to quickly find and delete links in excel.
  • How to link, link data between Excel filesHow to link, link data between Excel files
    when using excel, there are cases where the data resides in different excel files, and you need to get data from one excel spreadsheet to another. so you have to create data links between excel files so that data can be transferred automatically.
  • PowerPoint 2016: Hyperlink in PowerPointPowerPoint 2016: Hyperlink in PowerPoint
    if you want to include a web address or email address in your powerpoint presentation, you can choose to format it as a hyperlink, so others can easily click on it.
  • Hyperlink (Hyperlink) in PowerPoint 2016Hyperlink (Hyperlink) in PowerPoint 2016
    if you want to include a web address or email address in your powerpoint presentation, users can choose to format it as a hyperlink, so others can easily click on it.
  • Create Hyperlink in WordCreate Hyperlink in Word
    in the process of working with word, surely not less or less you will also need to insert website links, e-mail or links to files in your computer to make the text full and complete.
  • How to Automatically Report on ExcelHow to Automatically Report on Excel
    today's tipsmake will guide you how to automatically report data on microsoft excel. this article also talks about how to query and create reports from external sources (mysql, postgres, oracle, etc.) right on your spreadsheet using the excel plug-in to link your spreadsheet to the source. that data. as for data stored on excel spreadsheets, we will use macro commands to create and export reports into many different file types with just one keystroke. luckily, excel has this feature built in, so you won't need to create your own algorithm.