- 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
支付宝扫一扫 
评论列表（196条）
测试