How to add word document structure diagram in excel in Win7 system

How does Win7 system add word document structure diagram in excel

Method 1:

Word provides a very convenient function —— document structure diagram, through document structure diagram Quickly browse and track specific file content locations throughout the document. The document structure diagram is a separate window, similar to the outline view, which can display the title of the document. After clicking the title in the document structure diagram, Word will automatically go to the corresponding title in the document and display it in the window. top. The user can open it by clicking on the menu ““View”-“Document Map". However, there is no document structure diagram provided in EXCEL. How to manage excel files with large amount of data and a lot of content classification?

1. Add a column in the original data area (sheet1) to the line number ” Into the formula: = row ();

2, make a PivotTable, placed in sheet2. Drag the fields to the <quo;line";

according to the level requirements. 3. Add a column of navigation columns to sheet2 to go to the original data & rdquo;, write the formula, link to the line number of sheet1, for example :=HYPERLINK("#sheet1!a"&d16,"jump");

4. Click on the menu <;window”-“reorder window”-“ Vertical side by side <;

5, put the document structure chart (PivotTable) into the second window.

Method 2:

1. Open the Word2007 window and switch to the "View" ribbon. In the “View/Hide” section of the “View” section, select the “Document Structure” checkbox;

2. In the “Document Structure” pane that is open You can see the title structure of the document.