Ways to make Excel table catalogs

ways to make Excel table catalogs

For example: In an Excel workbook as shown in the following illustration, set up a link for each worksheet in the table of contents, and then set the link back to the main interface on each worksheet.

To set up the steps:

Step 1th: Select the cell that contains the list of B in the table of contents and click the Hyperlink command in the right-click menu, as shown in the following figure.

2nd step: In the Open Insert Hyperlink window, select location in this document on the left, and select a table sheet in the Right worksheet list box.

And so on, set the links to table two and table three.

Step 3rd: Set the return link for table one, table two, and table three. This time we can set up hyperlinks with the help of inserted graphics. The following illustration shows a graphic that is inserted. Select the graphic and select the hyperlink in the right-click menu. Set a link to the table of Contents worksheet in the Insert Hyperlink window.

After setting "table One", copy and paste the picture directly into table two and table three. The link will also be pasted with the picture. Our hyperlink settings are complete.