G Guest Apr 18, 2007 #2 Phil Ventresca said: How do I create an index or TOC for worksheets in an excel workbook? Click to expand... One good, easy way is Jim Cone's fine, free product (his XL Extras add-in) available at his page: http://www.realezsites.com/bus/primitivesoftware/products.php Scroll right down to the bottom of the page for the download link: XL Extras - release 1.21 ... Download A collection of additional features including... **create table of contents with hyperlinks to each sheet Jim's add-in will do exactly what you're looking for (and much more ..) After installing, just click Insert > Table of Contents (new menu item), then lounge back and watch Jim's magic go to work! ---
Phil Ventresca said: How do I create an index or TOC for worksheets in an excel workbook? Click to expand... One good, easy way is Jim Cone's fine, free product (his XL Extras add-in) available at his page: http://www.realezsites.com/bus/primitivesoftware/products.php Scroll right down to the bottom of the page for the download link: XL Extras - release 1.21 ... Download A collection of additional features including... **create table of contents with hyperlinks to each sheet Jim's add-in will do exactly what you're looking for (and much more ..) After installing, just click Insert > Table of Contents (new menu item), then lounge back and watch Jim's magic go to work! ---
D Dave Peterson Apr 18, 2007 #4 Is this to make navigation between sheets easier? If yes, you may want to try: http://contextures.com/xlToolbar01.html
Is this to make navigation between sheets easier? If yes, you may want to try: http://contextures.com/xlToolbar01.html