Excel tables can also generate catalogs with one click.

When there are too many worksheets in a workbook, it will be troublesome to find the worksheet you want every time, so it is suggested that you can make a navigation directory so that you can reach the specified form quickly.

1. Make the table catalog 1. Select all the worksheets first, and then enter "= XFD1" in any space.

2. Enter "File"-"Information"-"check problem"-"check compatibility"-"copy to New Table".

3. At this point, we generate a "compatibility report".

We remove the superfluous content above and keep only the hyperlink.

After getting rid of it, let's optimize it again.

4. Select the hyperlink cell and press "Ctrl + H" to replace the redundant content on the right.

5. Let's rename the worksheet again. Here, I'll change it to "directory".

6. Let's make a hyperlink back to each worksheet. Select all worksheets except contents, insert a row at the top, and enter the formula after merging:

= HYPERLINK "# directory A1" is returned

Take a look at our final effect!

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi