How to make intra-table links and inter-table links in Excel;
First, let's open the Excel table. Here, let's take the Sheet2 table as an example. Open the Sheet2 table, select cell A 1, right-click and select hyperlink.
In the pop-up menu box, select the location in this document, select sheet2 table, enter cell B2, and then click OK.
Then we click on cell A 1, and it will automatically jump to cell B 1! This intra-table link is completed.
Similarly, we can create a link between tables and right-click the hyperlink to select it. Just change the table in the previous step to sheet 1 and click OK.
When we click the cell A 1 in the sheet2 table, we will automatically jump to the sheet 1 table.