![how to edit table of contents in word that is not correct how to edit table of contents in word that is not correct](https://www.howtogeek.com/wp-content/uploads/2019/06/2019-07-10.png)
Just before saving and closing the file keep the content sheet active.For each TOC item, insert a hyperlink either to a sheet or a defined name.Identify ranges which are important for creating the TOC and assign names to them.Rename each sheet – never keep the defaults to Sheet1, Sheet2 and so on.You can also create and edit names using Formulas tab – Name Manager. Now these names appear in Hyperlink Dialog. Go to the name box, type a name and press ENTER. Therefore, Excel allows us to create other named items which can be used as hyperlink targets. In practice, sheet based navigation may not be enough – because, the same worksheet may have multiple areas of interest. By default, Excel allows you to create a hyperlink to existing sheets. As we saw in the last article, we can use a Hyperlink within a document to create a set of links. The problem: Excel does not provide a built-in feature to create a TOC. The solution: Create a Table of Contents for complex Excel workbooks
![how to edit table of contents in word that is not correct how to edit table of contents in word that is not correct](https://www.customguide.com/images/pages/word/table-of-contents-word.png)
This can lead to misinterpretation, erroneous decision making and chaos. This is a communication gap – which is difficult to bridge. The sender may have intended you to look at a particular sheet / range but in reality, you end up looking at some other area – and take some decision. Which does not necessarily mean that is the area of primary interest. Where do I start? Which areas am I supposed to view? The first sheet which opens is the sheet and the area of the sheet which was open at the time of last file save. How often have you received complex Excel files from others which have many worksheets, some color coded (but you don’t know the meaning of the color), some having similar names …lots of data, calculations, pivots, charts … and then you face a simple problem. The solution: Create a Table of Contents for complex Excel workbooks.