How to link to another sheet in excel?

#How to create a link to another sheet in excel?

Method 1: Insert a hyperlink

1. First, select "Insert - Hyperlink - Position in this document"; fill in the link to display Name, select the target sheet to be linked to;

2. Click the "OK" button to complete the settings.

Method 2: hyperlink function

1. Select a cell and select the function hyperlink;

#2. Hyperlink has two parameters: friendly_name is the link display word, and Link_location is the target area to link to.

When setting a link in the same file: the format of Link_location is: "#The name of a certain sheet page! A certain cell";

3 , the effect of the completed link is as follows:

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to link to another sheet in excel?. For more information, please follow other related articles on the PHP Chinese website!