How Do You Create A Linked Table Of Contents In Microsoft Excel?
When working with large spreadsheets with multiple tabs it becomes difficult and time consuming to navigate between tabs. Use the below instructions to create a linked table of contents that will allow you to click a cell and automatically be taken to the proper worksheet. Insert a new worksheet and place it to the extreme left or first position and rename it “Table of Contents” Name the first column accordingly. For example, if this is a spreadsheet tracking potential customers for your sales activities you may choose to name the first column “Customers”. Go down to the next row and type the name of your first worksheet that you need to link. After you have entered the name select the cell and right click on it and select “Hyperlink”. You can also select the cell and then use the menu bar to select “Insert” and then “Hyperlink”. The “Insert Hyperlink” dialog box will appear. Choose the “Document” tab and then click the “Locate” box next to “Anchor”. The “Select Place in Document” dial
