Instructions on how to create Hyperlink in Excel

Excel's Hyperlink is responsible for inserting web page links in Excel content. When people create spreadsheets and insert access links in Excel content, we can access the website quickly.

In order to be able to handle the statistics, or simply create a table, Microsoft Excel office tools are an effective support tool for anyone who has to deal with calculations. The more new versions of Excel come later, Microsft integrates many new features to serve the diverse needs of users.

The tips in Excel such as shortcut keys when processing Excel data, 10 ways to use the Paste feature in Excel, . will help operations with spreadsheets faster, more efficient than online operations. The system that we often use. Therefore, if the reader can know more Excel tips or operations with the data sheet, it will ensure the quality of the work. In the following article, we will show you how to use Hyperlink in Excel.

Step 1:

You enter content in Excel. In the content location Excel wants to insert Hyperlink , right- click and select Hyperlink .

Instructions on how to create Hyperlink in Excel Picture 1Instructions on how to create Hyperlink in Excel Picture 1

Step 2:

The Insert Hyperlink dialog box appears . Here, we will select Existing File or Web Page .

In the right interface, the Text to display section will display the text content on Excel that you want to insert. Under the Address section, enter the website address you want to insert . For example https://quantrimang.com/ . Finally click OK to save.

Instructions on how to create Hyperlink in Excel Picture 2Instructions on how to create Hyperlink in Excel Picture 2

Step 3:

Return to Excel data and see that Hyperlink has been created in your data content, with content printed in blue and underlined, more prominent in the entire spreadsheet.

Instructions on how to create Hyperlink in Excel Picture 3Instructions on how to create Hyperlink in Excel Picture 3

When we click on that content, the website link will appear. Now, you can quickly access any web page right in Excel content.

Instructions on how to create Hyperlink in Excel Picture 4Instructions on how to create Hyperlink in Excel Picture 4

Refer to the following articles:

  1. How to reopen Word, Excel or PowerPoint files when closed but not saved yet?
  1. 5 nightmares for Excel and how to fix it
  1. Simple way to convert XLSX files to XLS

Hope this article is useful to you!

5 ★ | 1 Vote