How to create a function index, how to create an index between excel

Excel often needs to use indexes, how to create indexes in Excel? Here's how I can index between excels, and I hope you'll be inspired after reading it!

Methods of indexing between excels

Figure 1 of the method of indexing between excelsStep 2: Right-click on the first worksheet, select the Insert command, and rename it to Index Directory.

Figure 2 of the method of indexing between excels

Figure 3 of the method of indexing between excels

Figure 4 of the method of indexing between excelsStep 3: Click to select the B1 cell in the Index Directory worksheet, and then click the definition name in the Formula menu.

The method of indexing between excel is shown in Figure 5To create an index, step 4: Enter the name [Index Directory] in the pop-up name window, enter the formula in the Reference Position text box, and click OK.

The method of indexing between excel is shown in Figure 6To create an indexStep 5: Click on cell B1 and enter the formula =iferror(hyperlink(Index directory&"!a1",mid(index,find(.]"]index directory)+1,99)), and then drag and drop to quickly fill the cells below.

The method of indexing between excel is shown in Figure 7

Figure 8 of the method of indexing between excels

How to create an index:

1. Open the word document that needs to be set, switch the main interface to "Page Layout", and find the "separator" in "Page Settings" in the "Page Layout" interface;

4. Click "Insert Table Directory" and select "Figure" in the interface where "Caption Label" appears"；

5. Select "Table" in the drop-down directory of "Caption Label" to change the type of index;

6. After selecting the label of "Figure", click "OK", and then the table of contents of the chart can be displayed in the original blank page, and the graph directory of the graph index is successfully set, that is, the index creation is completed.

1. First of all, click the "+" symbol below in Excel to create a new worksheet.

2. Double-click the name of the worksheet to change the name of the worksheet to "Index Directory".

3. Then design the required format and style in the cells of the simple table of contents page.

4. Then enter the "=" symbol in the position where you need to count it.

5. And switch to the position of **1, click the total position of the number that needs to be retrieved, and click enter, and the data of **1 can be taken out and displayed in the index page cell.

6. Use the same way to switch to **2 to select the position of the cell that needs to be taken.

7. Click the Enter button to generate the required data content in the index page.

Method Steps:

2. Right-click on the first worksheet, select the insert command, and rename it to [Index Directory].

3. Click to select the B1 cell in the [Index Directory] worksheet, and then click the definition name in the menu [Formula].

4. Enter the name [Index Directory] in the pop-up definition name window, then enter the formula in the reference position text box and click OK.

5. Click cell B1 and enter the formula =iferror(hyperlink(index directory&"!a1",mid(index,find(.]"]", index directory)+1,99)),"") OK and drag to quickly fill the cells below.

6. Now that the index is established, click on the chapter you need to jump directly to the worksheet.