Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about the usage of the hyperlink function in excel, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Today I would like to share with you the usage of hyperlink function in excel!

In fact, there are many ways to achieve the hyperlink effect in excel: direct manual settings, hyperlink functions, development tools, VBA and so on. But we often use the first two kinds in our work:

Manual setting method:

This way is relatively simple and easy to master, just click the mouse to select the link file.

First select the target cell

Then right-click-select a hyperlink

The insert hyperlink dialog box automatically opens:

This dialog box has a total of four main modules and two custom areas.

The text to be displayed-refers to the hyperlinked text that will be displayed later in the cell.

Address-represents the target file linked to.

Four optional items, such as web page, workbook file, new document and e-mail address are given on the left, which can be selected according to your needs.

Now I will display the text input: Baidu; enter Baidu URL in the address.

At this time, the target cell displays Baidu and already has the hyperlink function (the mouse hovering over the target cell will change into a small palm shape)

In fact, for the e-mail address, it is not so troublesome, as long as enter the URL mailbox number in the cell, the software can automatically identify and set to the hyperlink format. But the disadvantage is that the mailbox is displayed instead of the recipient, which can be directly displayed as the recipient name if you use the manual menu setting method just now)

All the mailboxes above are provided with hyperlinks, so you can click on them (the Windows mailbox will automatically activate the outlook mailbox configured by the system when the mailbox link is opened. Users who have not configured the mailbox need to configure it in advance)

Hyperlink function method:

The HYPERLINK function is a function that specifically sets hyperlinks in excel software. The specific usage is as follows:

After entering "= HYPERLINK (") directly into the cell, the software will directly give the function syntax hint.

Link_location refers to the path to the target file of the link, and friendly_name refers to the text displayed in the cell

Example:

= HYPERLINK ("C:\ Users\ Administrator\ Desktop\ common methods of search techniques .pdf", "search techniques")

In the same way: we can use the hyperlink function to set URL links and mailbox links.

The advantage of using the hyperlink function is that instead of using manual settings one by one, you just need to copy the formula. (especially if you need to set more hyperlinks, the benefits will be more obvious.)

After reading the above, do you have any further understanding of the use of hyperlink functions in excel? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.