![]() This named location will be the cell where the navigational button created in the steps below will lead. Start by placing your cursor at the top of the table of contents and in the Name Box (located directly above column A), type TOC and press the Enter key. ![]() The advantage of this alternative approach is that the separate column of hyperlinks (such as column C in the example above) is not necessary, but the disadvantage is that each hyperlink must be applied one at a time.)įurther, I recommend you insert a button on each worksheet that will return you to your table of contents, as follows: (As an alternative, you could instead select each name in the table of contents one at a time and press Ctrl+K to apply a hyperlink directly to each worksheet name. ![]() As a result, you will then be able to click each link to jump to the various worksheets listed in your table of contents.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |