Document editing comes as an element of numerous occupations and careers, which is the reason instruments for it must be reachable and unambiguous in terms of their use. A sophisticated online editor can spare you a lot of headaches and save a considerable amount of time if you need to Protect table of contents release.
DocHub is an excellent illustration of an instrument you can grasp in no time with all the useful functions at hand. Start modifying instantly after creating your account. The user-friendly interface of the editor will help you to find and employ any feature in no time. Notice the difference using the DocHub editor as soon as you open it to Protect table of contents release.
Being an important part of workflows, file editing should stay simple. Utilizing DocHub, you can quickly find your way around the editor making the desired modifications to your document without a minute wasted.
- [Jon] Welcome to Excel Campus. My name is Jon and in this video Im going to explain how to add a Table of Contents to your workbook that updates automatically. So here we have a simple Table of Contents sheet at the front of our workbook with clickable links to each sheet in the workbook. And whenever I make changes to the tabs in this workbook, whether I add or delete sheets or I rename a sheet, I want this Table of Contents to automatically update. And I have a macro that does this. Ill quickly show how it works. So if I just make a copy of this sheet here, left click and hold, hold down the control key and drag this to the right I now have a duplicate copy. Remove Duplicates (2), and then when I click the Table of Contents sheet my macro will run to automatically update my Table of Contents, and we can see that sheet has been added right here. So lets jump over to the VB Editor and see how this macro works. Developer tab, Visual Basic button, keyboard shortcut is Alt F11. So I