Home  >  Article  >  Topics  >  How to link to another sheet in excel?

How to link to another sheet in excel?

烟雨青岚
烟雨青岚Original
2020-06-24 14:20:5934982browse

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.

How to link to another sheet in excel?

Method 2: hyperlink function

1. Select a cell and select the function hyperlink;

How to link to another sheet in excel?

#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";

How to link to another sheet in excel?

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

How to link to another sheet in excel?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn