How to use hyperlink function

Usage of hyperlink function: When you click the cell where the HYPERLINK function is located, the linked file will be opened or jump to the cell range of the specified worksheet. The syntax is [HYPERLINK(link_location,friendly_name)].

Usage of hyperlink function:

First, introduction to the usage of hyperlink function

　The function of the hyperlink function in Excel is to create a shortcut. When you click the cell where the HYPERLINK function is located, the linked file will be opened or jump to the cell range of the specified worksheet.

The syntax of the hyperlink function is: HYPERLINK(link_location,friendly_name)

The first parameter of the hyperlink function is the path and file name of the file representing the hyperlink, or the cell address to be jumped. .

The second parameter of the hyperlink function is an optionally specified string or the value of a certain cell, which is the content displayed in the hyperlink cell.

Second, hyperlink function related examples

1. The hyperlink function links to the folder

Cell A1, enter the formula: =HYPERLINK("C:\Documents and Settings\Administrator\Desktop","excel forum")

means, when Click on cell A1 and use the hyperlink function to directly open the "excel forum" folder on the desktop.

2. The hyperlink function links to the specified file

In cell A1, enter the formula: =HYPERLINK("C:\Documents and Settings\Administrator\Desktop\hyperlink function information.doc","hyperlink function information")

means that clicking on cell A1 will open the doc document "Hyperlink Function Information" on the desktop.

3. The hyperlink function links to the specified location of the worksheet

Links to the specified location of the current worksheet, click to jump to the specified cell of the current worksheet. For example, in cell A1, enter the formula: =HYPERLINK("#B8","Jump to B8")

means that clicking cell A1 will jump to cell B8.

4． The hyperlink function links to the specified position or area of ​​other worksheets in the current workbook

For example, cell A1 input: = Hyperlink("#sheet2!B8","Jump to SHEET2 worksheet B8")

In addition, if the area has a defined name, such as the defined name X=sheet2!A10:B15, then the following formula or jump to the X area and select the area: = Hyperlink("# Name The hyperlink function links to the workbook and jumps to the specified location of the worksheet. The usage form is as follows:

Files in the same directory: =HYPERLINK("book2.xls#sheet2!a1","to BOOK2 in Sheet2!A1")

In different directories: =HYPERLINK("C:\My Documents\XLS\book2.xls#sheet2!a1","To BOOK2 in Sheet2!A1")

Related learning recommendations:

excel tutorial

The above is the detailed content of How to use hyperlink function. For more information, please follow other related articles on the PHP Chinese website!