Win7 how the system adds a Word Document Map to Excel

Win7 How the system adds a Word Document Map to Excel

Method One:

Word provides a handy feature-a document map that allows you to quickly browse and track specific file content locations throughout your document. A Document Map is a separate window, similar to outline view, that displays the title of a document, and when you click a heading in the Document Map, Word automatically moves to the corresponding heading in the document and displays it at the top of the window. The user can click the menu "View"-"Document Map" to open it. But Excel doesn't provide a document map, so how do you manage Excel files with a large amount of data and a lot of content sorted?

1, in the original data area (Sheet1) to add a column "line number", write formula: =row ();

2, make the PivotTable report, put in the Sheet2. Drag the field to row as required by the hierarchy;

3, add a list of navigation column "go to original data" in Sheet2, write formula, link to Sheet1 line number, for example: =hyperlink ("#sheet1!a" &d16, "jump");

4, click the menu "window"-"rearrange the window"-"vertical side";

5. Place the Document Map (PivotTable) in the second window.

Method Two:

1, open the Word2007 window, switch to the "view" Ribbon. In the view ribbon, in the Show/Hide group, select the Document Map check box;

2, you can see the title structure of the document in the Open Document Map pane.