#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!