Ways to easily create linked catalogs in Excel

ways to easily create linked catalogs in Excel

Excel worksheet name is a large string, it is inconvenient to view the data.

Create a table of contents, click on the link to switch.

The operation is actually very simple, let's look down together.

Select the worksheet first, and then right click on the label.

Formula A1 to enter, input complete enter enter.

=xfd1

Then the mouse point "file", compatibility performance to test.

Generate a worksheet, link obediently hide inside.

Links are copied to the table of contents, adjusting row heights and column widths.

Link catalog is finished, then make a return key.

The A2 formula is simple, with all worksheets selected.

=hyperlink ("#目录! A1 "," Back ")