:Find and reference functions HYPERLINK functions-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Create a shortcut (jump) to open a file stored on a network server, intranetor the Internet.

[ Intranet: A network within an organization that uses Internet technologies (such as HTTP or FTP protocols), through the use of hyperlinksYou canat span>

Browse objects, documents, web pages, and other targeted content on an intranet]

When you click the cell where the function HYPERLINK is located, WPS Sheet will open the linked file or jump to the specified worksheet cell.

Syntax
HYPERLINK(link_location, friendly_name)

￭ Link_location is the name or full path of the file to be opened. Can be a local hard drive, UNC path, or URL path.

￭ Link_location can be a text string enclosed in quotes, or a cell containing a link to a text string.

￭ If the jump specified in link_location does not exist or is inaccessible, an error message will appear when the cell is clicked.

Friendly_name is the jump text value or numeric value displayed in the cell. The contents of the cell are blue and underlined.

￭ If Friendly_name is omitted, the cell will display link_location as jump text.

Friendly_name can be a number, a text string, a name, or a cell containing jump text or a number.

If Friendly_name returns an error value (for example, #VALUE!), the cell displays the error value in place of the jump text.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/cha-zhao-he-yin-yong-han-shu-HYPERLINK-han-shu.html